Custom datestyle for timestamps

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Custom datestyle for timestamps
Дата
Msg-id b0419c22-44f0-46f7-9fa2-899e1cf3c91a@mm
обсуждение исходный текст
Ответы Re: Custom datestyle for timestamps
Список pgsql-general
  Hi,

SET DATESTYLE takes predefined keywords such as ISO or US as arguments,
but I can't find a way to specify a custom format string for
timestamps.

What I'd like to find is an equivalent to Oracle's
ALTER SESSION SET nls_date_format='DD/MM/YYYY HH24' for example,
where the format follows the sames rules than to_char and to_date.
This sets an implicit format for every subsequent text<->date
conversion.

Is there a way I could achieve that with postgres? A psql-only solution
would be good enough for me.

Thanks,

--
 Daniel

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