How to change default date format?

From: "Arunachalam Jaisankar" <jsankar(at)xtra(dot)co(dot)nz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to change default date format?
Date: 2003-03-15 06:38:45
Message-ID: 001101c2eabd$87e16790$020000c0@singlarc01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I've lot of date fields in my postgres tables. When ever I run a query on
date fields, the date is retrieved in
"yyyy-mm-dd" format. Every time, I've to use to_char function to convert
those fields into string. Is there is any server setting to change the
default date retrieval format into dd/mm/yyyy? Please let me know, if there
is any way. It will be really helpful for me.

Thanks & Regards
Jaisankar

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felix 2003-03-15 06:58:50 Encoding pltcl
Previous Message Lincoln Yeoh 2003-03-15 06:09:19 Re: The folding of unquoted names to lower case in