Tom Lane wrote:
> Asher Hoskins <asher(at)piceur(dot)co(dot)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.
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2010-03-02 18:14:00|
|Subject: Re: [GENERAL] trouble with to_char('L')|
|Previous:||From: Andrew Dunstan||Date: 2010-03-02 17:07:04|
|Subject: Re: USE_LIBXSLT in MSVC builds|
pgsql-general by date
|Next:||From: Lee Hachadoorian||Date: 2010-03-02 17:21:24|
|Subject: Array columns vs normalized table|
|Previous:||From: Miguel Angel Hernandez Moreno||Date: 2010-03-02 17:08:24|
|Subject: tipo de dato|