For tests proposes, I need to get the current system date. On Oracle we could use:
SELECT SYSDATE FROM DUAL
On SQL SERVER, we can use:
SELECT GETDATE() AS CurrentDateTime
How to query the system date time using SOQL?
You don't need to use SOQL. You can just create a new DateTime and set it to the current date and time like below
DateTime myDateTime = system.now();
Or if you only want the date, then
Date myDate = system.today();
If you cannot use Apex, and need to use SOQL only, then binding is not allowed. Which means you cannot use
With that in mind, you can use Date Literals, such as
TOMORROW, and so on.
SELECT CreatedDate FROM Account WHERE CreatedDate <= TODAY SELECT CreatedDate FROM Account WHERE CreatedDate <= YESTERDAY