[SalesForce] How to Get the Current System Time using SOQL

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?

Thanks.

Best Answer

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();
Related Topic