Tom Lane wrote:
> "Belinda M. Giardine" <giardine@bio.cse.psu.edu> writes:
>> Should it be this way?
>
> Well, to_timestamp() is apparently designed not to complain when the
> input doesn't match the format, which is not my idea of good behavior
> ... but your example is in fact wrong. 'Month' means a 9-character
> field, so you are short a couple of spaces.
The padding is on *input* too? Is this an Oracle compatibility "feature"?
--
Richard Huxton
Archonet Ltd