Re: to_timestamp not stable if date string shorter than template

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
Newsgroups: comp.databases.postgresql.bugs
Sent: Wednesday, September 03, 2003 1:05 AM
Subject: Re: to_timestamp not stable if date string shorter than template


> "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?

I get on Postgres 7.3.3:

test=# select to_timestamp('2003-06-01', 'YYYY-MM-DD HH24:MI:SS') ;
      to_timestamp
------------------------
 2003-06-01 00:08:00+02
(1 row)

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

test=# select to_timestamp('2003-06-01', 'YYYY-MM-DD HH24:MI:SS') ;
      to_timestamp
------------------------
 2003-06-01 00:08:00+02
(1 row)



Why 00:08:00+02 ?


Regards
Gaetano Mendola