>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