Re: [SQL] querying a column w/ timestamp with timezone datatype

On 01/30/2012 07:00 AM, Anson Abraham wrote: I an 9.1 PG database: I have a column which is a timestamp w/ time zone. So the value I have as one record in table is: 15:55:24.342848+00 If i want to find records less or greater than that timestamp, how do I construct the query? select * from

[SQL] querying a column w/ timestamp with timezone datatype

I an 9.1 PG database: I have a column which is a timestamp w/ time zone. So the value I have as one record in table is: 15:55:24.342848+00 If i want to find records less or greater than that timestamp, how do I construct the query? select * from schema.table where tscol >= '15:55:24.342848+00';