Re: date_part function
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Burski <John.Burski@911ep.com>
Cc: pgsql-novice@postgresql.org
Date: 2000-12-29T20:53:38Z
Lists: pgsql-novice
John Burski <John.Burski@911ep.com> writes:
> I submitted the following query:
> select date_part('dow', timestamp 'now');
> and received the following results:
> ERROR: Function 'date_part(text, timestamp)' does not exist
> Unable to identify a function which satisfies the given
> argument types
> You will have to retype your query using explicit typecasts
Odd. It works fine for me. What do you get from psql's "\df date_part"?
regards, tom lane