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