Re: Problem in converting int to timestamp value - why? - Mailing list pgsql-general

Michael Fuhr <mike@fuhr.org> writes:
> The leading space is confusing to_timestamp():

>   test=> SELECT to_timestamp(' 2004 12 17', 'YYYY MM DD');
>       to_timestamp
>   ---------------------
>    2171-11-06 06:00:00

I'd still say this is a bug.  If to_timestamp can't match the input to
the pattern, it should throw an error, not silently return garbage.

            regards, tom lane