How to get the database's current time?

[christianmarco_niedermaye]

Hello,

is there a select statement to retrieve the system time of MaxDB/SAPDB similar to the SQL Server statement "SELECT GETUTCDATE()"?

Thanks,

Christian

[alexander_schroeder]

In MaxDB, you can do, e.g., a

SELECT UTCDATE FROM DUAL

to select the current UTC timestamp at the server. You

may of course also use the UTCDATE statement in all

places where you could use a time stamp literal or

parameter.