DATETIME SQL TYPE

[Allen Pham]

Hello all,

Please help me with the following situation.

I am trying to run the following query:

"SELECT SUM(SUBTOTAL) FROM TRANSACTION WHERE DATE = CURDATE() AND NOT IS_VOIDED"

The DATE field is of type DATETIME (because I want to know both the date and
the time the transaction occured).

I have records that matches the criteria. However, when I run this query I get no
results back.

I have changed the DATE field to TIMESTAMP as well. I still don't get any results
back.

The documetation says the CURDATE() function works. Any clues?