From: | John Burski <John(dot)Burski(at)911ep(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | date_part function |
Date: | 2000-12-29 15:36:07 |
Message-ID: | 3A4CAF67.6ACFCF98@911ep.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I was putzing around with the date/time functions to get a feel for how
they work, when I ran across this bit of puzzling behavior. I'm running
PostgreSQL 7.0.3 on a Red Hat 6.1 box.
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
However, the user documentation seems to indicate that this function is
an integral part of PostgreSQL.
What gives?
Regards,
--
John Burski
Chief IT Cook and Bottlewasher
911 Emergency Products, St. Cloud, MN
(320) 656 0076
++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++
From | Date | Subject | |
---|---|---|---|
Next Message | D. Duccini | 2000-12-29 15:50:36 | Re: date_part function |
Previous Message | Karla Peralta | 2000-12-28 17:02:24 | Re: Transactions |