Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section


A date/time function that returns the current local date and time.




SYSDATE takes no arguments and returns the current local date and time as a timestamp in %TimeStamp data type format (yyyy-mm-dd hh:mm:ss.ffff). SYSDATE returns the current local date and time for this timezone; it adjusts for local time variants, such as Daylight Saving Time.

By default, SYSDATE returns time in whole second increments. This default can be configured.


SYSDATE is a synonym for the argumentless CURRENT_TIMESTAMP function. The CURRENT_TIMESTAMP function is preferred for use in Caché SQL. The SYSDATE function is provided for compatibility with other versions of SQL.

See Also