From: | "Eliel Mamousette" <eliel(at)panix(dot)com> |
---|---|
To: | "Karel Zak" <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | RE: to_timestamp busted? |
Date: | 2001-06-25 08:53:53 |
Message-ID: | 000101c0fd54$5c7d9c70$2001a8c0@blockhead |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Drat! User error strikes again.
Thanks for the fast eyes on this Karel!
-eliel
> -----Original Message-----
> From: Karel Zak [mailto:zakkr(at)zf(dot)jcu(dot)cz]
> Sent: Monday, June 25, 2001 4:25 AM
> To: Eliel Mamousette
> Cc: pgsql-general(at)postgresql(dot)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(at)zf(dot)jcu(dot)cz>
> http://home.zf.jcu.cz/~zakkr/
>
> C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
>
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Åkerud | 2001-06-25 09:32:26 | Re: Foreign Keys Constraints, perforamance analysis |
Previous Message | Karel Zak | 2001-06-25 08:25:10 | Re: to_timestamp busted? |