Re: Confused by to_char - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Confused by to_char
Date
Msg-id 1107867656.28433.9.camel@localhost.localdomain
Whole thread Raw
In response to Confused by to_char  (mike <mike@redtux1.uklinux.net>)
Responses Re: Confused by to_char
List pgsql-general
On Tue, 2005-02-08 at 12:28 +0000, 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=# select to_char('2005-02-07'::date,'Day');
  to_char
-----------
 Monday
(1 row)


gnari



pgsql-general by date:

Previous
From: Jim Wilson
Date:
Subject: Re: Safely Killing Backends (Was: Applications that leak connections)
Next
From: Chris Green
Date:
Subject: Re: Confused by to_char