Re: [GENERAL] to_timestamp() and quarters

2010-03-04 Thread Asher Hoskins
A. Kretschmer wrote: In response to Tom Lane : 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. *

Re: [GENERAL] to_timestamp() and quarters

2010-03-02 Thread Scott Bailey
Tom Lane wrote: 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 so

Re: [GENERAL] to_timestamp() and quarters

2010-03-02 Thread A. Kretschmer
In response to Tom Lane : > 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. > * >

Re: [GENERAL] to_timestamp() and quarters

2010-03-02 Thread Tom Lane
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 a

[GENERAL] to_timestamp() and quarters

2010-03-02 Thread Asher Hoskins
Hello. I can't seem to get to_timestamp() or to_date() to work with quarters, can anyone see what I'm doing wrong? e.g. select to_date('2010-1', '-Q'); Gives "2010-01-01" (correct). select to_date('2010-3', '-Q'); Also gives "2010-01-01" (should be 2010