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.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
