Re: to_timestamp() and quarters
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Asher Hoskins <asher@piceur.co.uk>
Cc: pgsql-general@postgresql.org
Date: 2010-03-02T14:54:15Z
Lists: pgsql-hackers, 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