output format for dates

Поиск
Список
Период
Сортировка
От am@fx.ro
Тема output format for dates
Дата
Msg-id 20020922185325.A232@coto
обсуждение исходный текст
Ответы Re: output format for dates  (Alvaro Herrera <alvherre@atentus.com>)
Список pgsql-general
hello all!

I need a piece of advice regarding date styles. I've tried all
the datestyles, but none of them seems to look the way i want.

I would like to use the following format for dates:
DD-MON-YYYY or DD-MON-YY, where MON is one of : JAN,FEB,..,DEC.
(for example 20-APR-2002) for both input and output.

I've noticed that Postgres accepts dates in this format, so the
input part is ok. But for output, it uses the 'european' style.

So, here comes my question:  is it possible to create a new
custom datestyle and set it as default ?


Thanks in advance,
Adrian Maier (am@fx.ro)

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: User Defined Functions
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Book recommendation