Postgres Pro
Downloads
Home   >   mailing lists

How to change default date format? - Mailing list pgsql-general

From Arunachalam Jaisankar
Subject How to change default date format?
Date
Msg-id 001101c2eabd$87e16790$020000c0@singlarc01
Whole thread Raw
In response to The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard  ("David Delorme" <ddelorme@dmdelorme.ca>)
Responses Re: How to change default date format?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: The folding of unquoted names to lower case in
Next
From: Tom Lane
Date:
Subject: Re: The folding of unquoted names to lower case in