Re: to_timestamp busted?

From: Tod McQuillin <devin(at)spamcop(dot)net>
To: Eliel Mamousette <eliel(at)panix(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: to_timestamp busted?
Date: 2001-06-26 08:48:52
Message-ID: Pine.GSO.4.33.0106260346490.11234-100000@sysadmin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 25 Jun 2001, Eliel Mamousette wrote:

> But using:
>
> SELECT to_timestamp(log_date || ' ' || log_time,
> 'YYYY-MM-DD HH24:MM:SS'),
> log_date,
> log_time
> FROM iis_log limit 10;

Hold on... you said MM twice -- once in the date and once in the time. I
don't expect you have months in your time, do you?

Try 'YYYY-MM-DD HH24:MI:SS'
--
Tod McQuillin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-06-26 09:08:31 Re: Stored procedures?
Previous Message Oliver Vecernik 2001-06-26 08:40:50 Re: Stored procedures?