Hello Leo,
which version of PostgreSQL are you running? I tested:
select to_char(abm_dat, 'DD/MM/YYYY') AS new_date
from t_dummy;
And it works fine:
new_date
------------
31/03/1992
15/06/1994
11/09/1993
19/11/1993
...
Regards, Jens
Leo Xavier schrieb:
> [...]
> doing this:
> SELECT to_char(field, 'DD/MM/YYYY') AS new_date
>
> as Francis Solomon said, didnt work... "unrecognized function" ...
> [...]
=============================================
Jens Hartwig
---------------------------------------------
debis Systemhaus GEI mbH
10875 Berlin
Tel. : +49 (0)30 2554-3282
Fax : +49 (0)30 2554-3187
Mobil : +49 (0)170 167-2648
E-Mail : [EMAIL PROTECTED]
=============================================
