Re: to_timestamp busted?

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Eliel Mamousette <eliel(at)panix(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_timestamp busted?
Date: 2001-06-25 08:25:10
Message-ID: 20010625102510.A16959@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eliel Mamousette 2001-06-25 08:53:53 RE: to_timestamp busted?
Previous Message Eric G. Miller 2001-06-25 07:06:46 Re: to_timestamp busted?