Re: New to_timestamp implementation is pretty strict

On Dec 1, 2008, at 1:08 PM, Heikki Linnakangas wrote:

> postgres=# SELECT to_timestamp('29-12-2005 01:02:3', 'DD-MM-YYYY
> HH24:MI:SS'); -- doesn't work
> ERROR: source string too short for "SS" formatting field
> DETAIL: Field requires 2 characters, but only 1 remain.
> HINT: If your source string is not fixed-width, try using the "FM"
> modifier.
>
> I think the end of string should be treated like a field separator,
> colon in this example, and we should accept both of the above.
> Opinions?

I'm generally in favor of being generous in the input one can accept,
but in this case it seems ambiguous to me. Is that supposed to be :30
or :03? There's no way to tell.

My $0.02.

Best,

David