Skip to Content

How to get the database's current time?

Hello,

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

Thanks,

Christian

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Aug 20, 2004 at 08:41 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded