pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedoutputting dates
2+ messages / 2 participants
[nested] [flat]
* outputting dates
@ 2005-03-14 03:47 Kenneth Gonsalves <lawgon@thenilgiris.com>
0 siblings, 1 reply; 2+ messages in thread
From: Kenneth Gonsalves @ 2005-03-14 03:47 UTC (permalink / raw)
To: pgsql-sql
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
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: outputting dates
@ 2005-03-15 14:06 Christoph Haller <ch@rodos.fzk.de>
parent: Kenneth Gonsalves <lawgon@thenilgiris.com>
0 siblings, 0 replies; 2+ messages in thread
From: Christoph Haller @ 2005-03-15 14:06 UTC (permalink / raw)
To: Kenneth Gonsalves <lawgon@thenilgiris.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-15 14:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-14 03:47 outputting dates Kenneth Gonsalves <lawgon@thenilgiris.com>
2005-03-15 14:06 ` Christoph Haller <ch@rodos.fzk.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox