From: | Dragan Matic <mlists(at)panforma(dot)co(dot)yu> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Timestamp comparison with string in some special cases |
Date: | 2007-11-19 17:03:36 |
Message-ID: | 4741C1E8.4060107@panforma.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sam Mason wrote:
> On Mon, Nov 19, 2007 at 04:52:10PM +0100, Dragan Matic wrote:
>
>> select * from table where timestamp_column < '11/19/2007 15:46:09 PM'
>>
>
> Maybe the to_timestamp() function would help you:
>
> SELECT to_timestamp('11/19/2007 15:46:09 PM','MM/DD/YYYY HH24:MI:SS')
> -> 2007-11-19 15:46:09+00
>
> That just ignores the AM/PM flag, which may or may not be what you want
> to do.
>
>
> Sam
>
>
>
Tnx, this helped a lot. But not, I am confused with something. I thought
there supposed to be an implicit conversion from string to timestamp in
the first case. And isn't this:
SELECT * from table where timestamp_column < to_timestamp('11/19/2007
15:46:09 PM','MM/DD/YYYY HH24:MI:SS')
just doing the same thing that implicit string to timestamp conversion
should have done in the first case?
Dragan Matic
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2007-11-19 17:14:00 | Re: Compressed Backup too big |
Previous Message | Scott Marlowe | 2007-11-19 16:58:52 | Re: [GENERAL] Error while starting postgreSQL service |