From: | "D(dot) Duccini" <duccini(at)backpack(dot)com> |
---|---|
To: | John Burski <John(dot)Burski(at)911ep(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: date_part function |
Date: | 2000-12-29 15:50:36 |
Message-ID: | Pine.GSO.4.03.10012290950170.11673-100000@ra.bpsi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
try this
duccini=> select date_part('dow', 'now'::date);
date_part
---------
5
(1 row)
-duck
On Fri, 29 Dec 2000, John Burski wrote:
> 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? +
> ++++++++++++++++++++++++++++++++++
>
>
>
-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | John Burski | 2000-12-29 16:12:05 | Re: date_part function |
Previous Message | John Burski | 2000-12-29 15:36:07 | date_part function |