How to change default date format?

Поиск
Список
Период
Сортировка
От Arunachalam Jaisankar
Тема How to change default date format?
Дата
Msg-id 001101c2eabd$87e16790$020000c0@singlarc01
обсуждение исходный текст
Ответ на The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard  ("David Delorme" <ddelorme@dmdelorme.ca>)
Ответы Re: How to change default date format?  (Oliver Elphick <olly@lfix.co.uk>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: The folding of unquoted names to lower case in
Следующее
От: Tom Lane
Дата:
Сообщение: Re: The folding of unquoted names to lower case in