Re: [GENERAL] To many records returned

[Rodrigo Gonzalez]

Justin escribió:

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

but when the query includes casting to date


What is causing the difference in the results

Select * from sometable where DateStampColumn::date > '2008-03-31' The result is correct My guess is '2008-03-31' is being cast into a datestamp value of 2008-03-31 00:00:00.00-00 which would explain why one query returns more records.

I am almost sure your problem is that casting is done to text....so

2008-03-31 00:00:01 is greater than 2008-03-31 so that date is included....

Explicit casting is the right thing to do (your second query)

smime.p7s
Description: S/MIME Cryptographic Signature