Re: [SQL] RE: DATE Formating Problem Again

On Thu, 2 Mar 2000, Mark Kirkwood wrote:

> >I am searching after the date formatting solution, but didn't found a
> >correct one.
> >
> >So example ORACLE has
> > - to_char function to make any kind of date format from a date
> type:
> >to_char(now,'yyyy.mm.dd')
> > - to_date to makes a date type from any kind of string: to_date
> >('1999.11.23','yyyy.mm.dd')
> >(sniped...)
>
> I have wrestled a bit with this myself - being an Oracle dba ( but i'm
> alright now....),
> the date <-> char conversion is very different is Postgresql.
>
> However I have found that the "date_part" and "interval" functions seem
> to do the job ok,
> sometimes combined with the casting operator "::datetime".
>
> e.g : ( for release 7.0 )
> date -> number

The release 7.0 has to_char/to_date/to_timestamp functions too,
and it is very compatible with Oracle's to_char(). See the PostgreSQL
documentation for more details.

Karel