Re: [SQL] parts of date_part()

According to Herouth Maoz:
>
> Actually, it is an RTFM...
>
> >From the manpage of pgbuiltin (my postgres version is 6.2.1):
>
>      For the date_part() and  date_trunc()  functions,  arguments
>      can   be  `year',  `month',  `day',  `hour',  `minute',  and
>      `second',  as  well  as  the  more  specialized   quantities
>      `decade',   `century',   `millenium',   `millisecond',   and
>      `microsecond'.  date_part() allows `dow' to  return  day  of
>      week  and  `epoch' to return seconds since 1970 for datetime
>      and 'epoch' to return total elapsed seconds for timespan.

Is there any documentation (or is any needed) for the equivalent functions
mapped to their SQL92  "extract (field from value)" syntax?

Since I just ran across:
psql=> select date_part('month','01-01-1998'::date);
date_part
---------
       12
(1 row)
and the extract() does the same in this case, I'm being a little cautious...

 Les Mikesell
   les@mcs.com