Justin <justin@xxxxxxxxxxxxxxx> writes: > Have a select statement with a where clause using datestamp with > timezone column compared to a date > Select * from sometable where DateStampColumn > '2008-03-31' > this returns records that are equal 2008-03-31 There's no such thing as "timestamp compared to date". The date promotes to a timestamp at midnight; what you wrote is equivalent to Select * from sometable where DateStampColumn > '2008-03-31 00:00:00' > but when the query includes casting to date > Select * from sometable where DateStampColumn::date > '2008-03-31' > The result is correct You threw away the intraday part of the timestamp... regards, tom lane
