select with curdate and time

[nikko50]

I have 2 fields in my "users" table called LAST_INVOICE_DATE and LAST_INVOICE_TIME. These fields contain the last date and time of a invoice a user was working with. I want to select all invoices where LAST_INVOICE_DATE and LAST_INVOICE_TIME are older then 30 minutes of the current date and time.

[bradgrafelman]

Is there any reason you didn't store those two values together in a single DATETIME column, so that you could then utilize the built-in Date and Time Functions?