Re: to_timestamp not stable if date string shorter than template - Mailing list pgsql-bugs

"Stacy White" <harsh@computer.org> writes:
> to_timestamp appears to pick up the time-of-day from the previous call's
> return value if a date string has no time component.  For example:

Weird.  I do not see that here, on either 7.3.4 or current sources.
Can anyone else reproduce it?

For the record, I get:

regression=#  select to_timestamp('2003-06-01', 'YYYY-MM-DD HH24:MI:SS') ;
      to_timestamp
------------------------
 2003-06-01 00:00:00-04
(1 row)

regression=#  select to_timestamp('2003-06-02 12:13:14', 'YYYY-MM-DD HH24:MI:SS') ;
      to_timestamp
------------------------
 2003-06-02 12:13:14-04
(1 row)

regression=#  select to_timestamp('2003-06-01', 'YYYY-MM-DD HH24:MI:SS') ;
      to_timestamp
------------------------
 2003-06-01 00:00:00-04
(1 row)


            regards, tom lane