Re: order by day or month, etc - Mailing list pgsql-sql

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
=============================================