Caché SQL Reference
CURTIME
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

A scalar date/time function that returns the current local time.
Synopsis
{fn CURTIME()}
{fn CURTIME}
Description
CURTIME takes no arguments and returns the time as a TIME data type. Note that the argument parentheses are optional. CURTIME returns the current local time for this timezone; it adjusts for local time variants, such as Daylight Saving Time.
CURTIME in Logical mode returns the current local time in $HOROLOG format; for example, 37065. CURTIME in Display mode returns the current local time in the default format for the locale; for example, 10:18:27.
Hours are represented in 24–hour format.
To change the default time format, use the SET OPTION command with the TIME_FORMAT and TIME_PRECISION options.
To return just the current time, use CURTIME or CURRENT_TIME. These functions return their values in TIME data type. The CURRENT_TIMESTAMP, GETDATE and NOW functions can also be used to return the current date and time as a TIMESTAMP data type.
Note that all Caché SQL time and date functions except GETUTCDATE are specific to the local time zone setting. To get a current timestamp that is universal (independent of time zone) you can use GETUTCDATE or the ObjectScript $ZTIMESTAMP special variable.
These data types perform differently when using embedded SQL. The TIME data type stores values as integers in $HOROLOG format (as the number of seconds since midnight); when displayed in SQL they are converted to time display format; when returned from embedded SQL they are returned as integers. A TIMESTAMP data type stores and displays its value in the same format. You can use the CAST or CONVERT function to change the datatype of times and dates.
Examples
The following examples both return the current system time:
SELECT {fn CURTIME()} AS TimeNow
 
SELECT {fn CURTIME} AS TimeNow
 
The following Embedded SQL example returns the current time. Because this time is stored in $HOROLOG format, it is returned as an integer:
  &sql(SELECT {fn CURTIME} INTO :a)
  IF SQLCODE'=0 {
    WRITE !,"Error code ",SQLCODE }
  ELSE {
    WRITE !,"Current time is: ",a }
 
The following example sets the LastCall field in the selected row of the Contacts table to the current system time:
UPDATE Contacts Set LastCall = {fn CURTIME()}
  WHERE Contacts.ItemNumber=:item
See Also