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()
On DB2 we would use: Select current timestamp from sysibm.sysdummy1
I see this question was asked. How to Get the Current System Time using SOQL
However the response did not answer the question completely.
I have same question.
Notice for Oracle it uses generic DUAL table for the from. Notice for SQL Server you do not even have to specify a from table to get the date returned. Notice from DB2 it uses a generic sysdummy1 table for the from.
I would like to know how to use the select to get the sysdate returned in salesforce.
This needs to be generic way to get the system date returned without specifying a from table.