RE: to_timestamp busted?

Drat!  User error strikes again.

Thanks for the fast eyes on this Karel!

-eliel

> -----Original Message-----
> From: Karel Zak [mailto:zakkr@zf.jcu.cz]
> Sent: Monday, June 25, 2001 4:25 AM
> To: Eliel Mamousette
> Cc: pgsql-general@postgresql.org
> Subject: Re: to_timestamp busted?
>
>
> On Mon, Jun 25, 2001 at 02:03:55AM -0400, Eliel Mamousette wrote:
>
> > SELECT to_timestamp(log_date || ' ' ||  log_time,
> >         'YYYY-MM-DD HH24:MM:SS'),
>                                  ^^
>     MM = month number
>     MI = minutes
>
> test=# select to_timestamp('2001-06-20 00:05:54', 'YYYY-MM-DD
> HH24:MI:SS');
>       to_timestamp
> ------------------------
>  2001-06-20 00:05:54+02
> (1 row)
>
>                 Karel
>
>
> --
>  Karel Zak  <zakkr@zf.jcu.cz>
>  http://home.zf.jcu.cz/~zakkr/
>
>  C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
>