Tom Lane wrote:
"Belinda M. Giardine" <giardine@xxxxxxxxxxxxxxx> 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
