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?
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