docs.intersystems.com
Home / InterSystems SQL Reference / SQL Functions / SYSDATE


InterSystems SQL Reference
SYSDATE
Previous section           Next section
InterSystems: The power behind what matters   
Search:  


A date/time function that returns the current local date and time.
Synopsis
SYSDATE
Description
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.
Note:
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


Previous section           Next section
View this book as PDF
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-02-16 01:08:12