Postgres Pro
Downloads
Home   >   mailing lists

Confused by to_char - Mailing list pgsql-general

From mike
Subject Confused by to_char
Date
Msg-id 1107865707.5972.15.camel@datacc
Whole thread Raw
Responses Re: Confused by to_char  (Ragnar Hafstað <gnari@simnet.is>)
Re: Confused by to_char  (Chris Green <chris@areti.co.uk>)
List pgsql-general
Tree view 
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 I am doing wrong

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: indexing just a part of a string
Next
From: Jim Wilson
Date:
Subject: Re: Safely Killing Backends (Was: Applications that leak connections)