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 Tom Lane <tgl@sss.pgh.pa.us>
Re: to_timestamp() and quarters "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: to_timestamp() and quarters Asher Hoskins <asher@piceur.co.uk>
Re: to_timestamp() and quarters Scott Bailey <artacus@comcast.net>
Asher Hoskins  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
Дата:
От: Thom Brown
Дата:
FAQ