On Mon, Dec 1, 2008 at 10:33 AM, Greg Stark <[EMAIL PROTECTED]> wrote: > How would you parse an input format of just 'SS' ? is there something > ambiguous about '3' ? I don't see anything "bad" about using %d to > output an integer number of seconds.
+1. It seems to me that it's pretty silly to say that we "know" that the 2 in "01:2:03" is intended to mean 02, but we are somehow confused about whether the 3 in "01:02:3" is intended to mean 03 or 30. Sure, the latter could be the result of a truncation, but if the user is randomly truncating their strings, they're going to have problems with a lot more than to_timestamp(). ...Robert -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
