SQL Expression to get current date
Posted on 2002-07-19
I'm trying to run a query in a QReport that selects rows based on the current date and time, as in
SELECT * FROM Calls
WHERE ((DeadlineDate < ??CurrentDate??) OR ((DeadlineDate = ??CurrentDate??) AND (DeadlineTime < ??CurrentTime??))
Any ideas as to what should go between the ??'s? I've tried things like GetDate() and SYSDATE to no avail.