| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com> |
| Cc: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: outputting dates |
| Date: | 2005-03-15 14:06:18 |
| Message-ID: | 4236EBDA.5012F012@rodos.fzk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2005-03-15 14:20:14 | Re: select multiple immediate values, but in multiple rows |
| Previous Message | Christoph Haller | 2005-03-15 12:24:50 | Re: How to force subquery scan? |