Home  /  Application Development: Core Topics  /  InterSystems SQL Reference  /  SQL Functions  /  SYSDATE

InterSystems SQL Reference
[Back]  [Next] 
InterSystems: The power behind what matters   

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 either %TimeStamp data type format (yyyy-mm-dd hh:mm:ss.ffff) or %PosixTime data type format (an encoded 64-bit signed integer). 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 InterSystems SQL. The SYSDATE function is provided for compatibility with other versions of SQL.
See Also