Thread: outputting dates

outputting dates

From
Kenneth Gonsalves
Date:
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

http://www.livejournal.com/users/lawgon
tally ho! http://avsap.sourceforge.net
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!


Re: outputting dates

From
Christoph Haller
Date:
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