From: | John Burski <John(dot)Burski(at)911ep(dot)com> |
---|---|
To: | |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: date_part function |
Date: | 2000-12-29 16:12:05 |
Message-ID: | 3A4CB7D5.A3B9E9DA@911ep.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Just the ticket!
Thanks!
"D. Duccini" wrote:
> 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!"
> -----------------------------------------------------------------------------
--
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 | chris Gnther | 2000-12-29 16:23:55 | how to get trigger start function not procedure |
Previous Message | D. Duccini | 2000-12-29 15:50:36 | Re: date_part function |