Re: order by day or month, etc

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 : jhartwig(at)debis(dot)com
=============================================