Re: to_timestamp busted? - Mailing list pgsql-general

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