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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz