RE: DATE Formating Problem Again

>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

db1=> select date_part('year',now());date_part
-----------     2000

and  char -> interval
db1=> select interval('4 hours'::interval);?column?
----------04:00

and char -> datetime via interval
db1=> select ('1999-01-01 '||interval('4 hours'::interval))::datetime;       ?column?
------------------------1999-01-01 04:00:00+13

I hope this helps a bit...

Cheers

Mark