SYSTIMESTAMP Function - Oracle to MariaDB Migration

In Oracle, the SYSTIMESTAMP function returns the current date and time with fractional seconds and with the time zone of the current database instance.

In MariaDB, you can use the NOW(6) function that also include fractional seconds but does not include time zone.

Oracle:

  -- Get the current datetime 
  SELECT SYSTIMESTAMP FROM dual;
  /* 26-FEB-25 01.31.57.755000 PM +01:00 */

MariaDB - Oracle Compatibility:

  -- Get the current datetime
  SELECT NOW(6);
  /* 2025-02-26 13:31:57.755000 */

For more information, see Oracle to MariaDB Migration - Oracle Compatibility Mode.