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
> > - to_date to makes a date type from any kind of string: to_date
> 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.
In response to
pgsql-sql by date
|Next:||From: Emils Klotins||Date: 2000-03-02 15:10:07|
|Subject: date_part - multiple values in format?|
|Previous:||From: Mark Kirkwood||Date: 2000-03-02 09:54:54|
|Subject: RE: DATE Formating Problem Again|