Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting
Дата
Msg-id 26842.1587303735@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Possibly misleading documentation of Template Patterns forDate/Time Formatting  (David Kubecka <davidkubecka366@gmail.com>)
Ответы Re: Possibly misleading documentation of Template Patterns forDate/Time Formatting  (David Kubecka <davidkubecka366@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
David Kubecka <davidkubecka366@gmail.com> writes:
> Anyway, could you shed some light if there's any particular reason why TO_DATE(
> '2012-4', 'YYYY-Q' ) isn't supported?

You can't compute a specific date from that.  Nor does it lend itself to
combination with other fields to reach a specific date --- adding DD
doesn't do it, and if you add MM, you might as well not bother with Q.

            regards, tom lane

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

Предыдущее
От: David Kubecka
Дата:
Сообщение: Re: Possibly misleading documentation of Template Patterns forDate/Time Formatting
Следующее
От: Hritik Gupta
Дата:
Сообщение: Re: BUG #16373: Behavior of Temporary table creation