InterSystems IRIS Data Platform 2019.2  /  InterSystems SQL Reference  /  SQL Functions

InterSystems SQL Reference
Previous section           Next section
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

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-09-19 06:56:35