Kenneth Gonsalves wrote:
>
> hi,
> i have set my datetype to 'European, SQL'. This correctly accepts
> dates of the form dd/mm/yyyy. However, the output is still in the
> 'yyyy-mm-dd' format. How do i get the default output as dd/mm/yyyy?
> --
> regards
> kg
>
I have
select version();
version
-------------------------------------------------------------------------------------PostgreSQL 7.4.5 on
i686-pc-linux-gnu,compiled by GCC gcc (GCC) 3.3.1
(SuSE Linux)
I did
set datestyle to 'European, SQL';
SET
select date_trunc( 'day' , now() ); date_trunc
-------------------------15/03/2005 00:00:00 CET
How did you set your datetype?
Regards, Christoph
