From: Christoph Haller <ch@rodos.fzk.de>
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: outputting dates
Date: Tue, 15 Mar 2005 15:06:18 +0100
Message-ID: <4236EBDA.5012F012@rodos.fzk.de> (raw)
References: <200503140917.34875.lawgon@thenilgiris.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, lawgon@thenilgiris.com
Subject: Re: outputting dates
In-Reply-To: <4236EBDA.5012F012@rodos.fzk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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