Re: How to change default date format?

On Sat, 2003-03-15 at 06:38, Arunachalam Jaisankar wrote:
> Hi All,

It's not a good idea to reply to a message with a completely unrelated
subject; start a new thread.

> 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.

SET DATESYTLE TO SQL,European;

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Blessed are the poor in spirit, for theirs is the
kingdom of heaven...Blessed are they which do hunger
and thirst after righteousness, for they shall be
filled...Blessed are the pure in heart, for they shall
see God." Matthew 5:3,6,8