Re: to_timestamp() and quarters

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: to_timestamp() and quarters
Дата
Msg-id 15109.1267541655@sss.pgh.pa.us
обсуждение исходный текст
Ответ на to_timestamp() and quarters  (Asher Hoskins <asher@piceur.co.uk>)
Ответы Re: to_timestamp() and quarters  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: to_timestamp() and quarters  (Scott Bailey <artacus@comcast.net>)
Список pgsql-general
Asher Hoskins <asher@piceur.co.uk> writes:
> I can't seem to get to_timestamp() or to_date() to work with quarters,

The source code says

                 * We ignore Q when converting to date because it is not
                 * normative.
                 *
                 * We still parse the source string for an integer, but it
                 * isn't stored anywhere in 'out'.

That might be a reasonable position, but it seems like it'd be better to
throw an error than silently do nothing.  Anybody know what Oracle does
with this?

            regards, tom lane

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

Предыдущее
От: Antonio Goméz Soto
Дата:
Сообщение: Re: How to grant a user read-only access to a database?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: How to grant a user read-only access to a database?