Re: to_timestamp busted? - Mailing list 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