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