Re: [GENERAL] Confused by to_char

On Tue, 2005-02-08 at 13:00 +, Ragnar Hafstaà wrote: > On Tue, 2005-02-08 at 12:28 +, mike wrote: > > I am am trying to get a day string from a date using to_char ie: > > > > SELECT date1,ti1 ,to1,ti2,to2,adj,ei,eo,to_char('2005-02-07','Day') FROM > > vw_times_list1 > > > > however I get

Re: [GENERAL] Confused by to_char

On Tue, Feb 08, 2005 at 12:28:26PM +, mike wrote: > I am am trying to get a day string from a date using to_char ie: > > SELECT date1,ti1 ,to1,ti2,to2,adj,ei,eo,to_char('2005-02-07','Day') FROM > vw_times_list1 > > however I get > > function to_char("unknown", "unknown") is not unique > >

Re: [GENERAL] Confused by to_char

On Tue, 2005-02-08 at 12:28 +, mike wrote: > I am am trying to get a day string from a date using to_char ie: > > SELECT date1,ti1 ,to1,ti2,to2,adj,ei,eo,to_char('2005-02-07','Day') FROM > vw_times_list1 > > however I get > > function to_char("unknown", "unknown") is not unique test=# sele

[GENERAL] Confused by to_char

I am am trying to get a day string from a date using to_char ie: SELECT date1,ti1 ,to1,ti2,to2,adj,ei,eo,to_char('2005-02-07','Day') FROM vw_times_list1 however I get function to_char("unknown", "unknown") is not unique (using to_date does not recognise the date format) anyone any ideas what