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/199215/06/199411/09/199319/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 : jhartwig@debis.com
=============================================