>I have a MySql table with a DateTime field. I want to get all the records for today.
>ldDate = DATE()
>=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE dtField = ?ldDate")
>This produces no records, which is expected since I'm not accounting for the time portion of the field. But when I tried
>=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE DATE(dtField) = ?ldDate")
>I also got no records back. When I tried
>ldDate = DATE()
>lcDate = TRANSFORM(DTOS(ldDate),"@R 9999-99-99")
>=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE DATE(dtField) = ?lcDate")
>I got the records I wanted.
>
>Could somebody tell me why passing a Date value doesn't work while passing a character representation of the date does work?
>
>Thanks............Rich
Use lower range and upper range instead, e.g.
ldStartDate = Date()
ldEndDate = date() + 1
=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE dtField >= ?ldStartDate and dtField < ?ldEndDate")
If it's not broken, fix it until it is.
My Blog