SQL Get the Date only from DateTimestamp Field?

DaveB · Post by **DaveB** » 25.11.2007, 13:59

I want to Query using TZQuery but the Date field is a DateTimeStamp

So my param is passed like MyQuery.ParamByName('aDate').AsDate

Because of the time part of the field I seem to need to always add one
to the date to get the correct range.

In other DB Engines I believe in the SQL I can do
WHERE DATE(MYDATE) = :aDate

Which strips just the Date and gives me a true result.

Is there SQL ability like this using ZEOS?

Thank you

Gerard · Post by **Gerard** » 27.11.2007, 12:20

What database are you using? (MSSQL, Postgres, etc.)

DaveB · Post by **DaveB** » 27.11.2007, 12:24

Using Firebird

Gerard · Post by **Gerard** » 27.11.2007, 16:19

I don't know firebird at all. The link below has an example of casting time/date types in firebird.

http://www.firebirdsql.org/index.php?op ... stenried_1