Re: to_timestamp() and quarters

Tom Lane wrote:
> 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?

+1 for throwing error.
Oracle 10g throws ORA-01820: format code cannot appear in date input format.

Scott