InterSystems Programming Tools Index
Date/Time Values
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Work with date/time values.
Available Tools
The tools are grouped into the following categories: data type classes and tools to work with date/time values.
Available Data Type Classes
Class Name Logical Value ODBC Type XSD Type
%Date A date value in $HOROLOG format (see Current Date and Time). For example: 46674 DATE date
%Time A time value, expressed as the number of seconds past midnight. For example: 67080 TIME time
%TimeStamp A date value and a time value, in ODBC format (in YYYY-MM-DD HH:MM:SS.nnnnnnnnn). For example: 1968-10-15 18:38:47 TIMESTAMP dateTime
%UTC A UTC date and time value, in ODBC format. TIMESTAMP  
%MV.Date A MultiValue date. For example: 289 DATE date
Availability: All namespaces.
Available Tools for Working With Date/Time Values
%SYSTEM.SYS class
Includes the TimeZone() class method.
Availability: All namespaces.
%SYSTEM.SQL class
Includes class methods that you can use to work with date/time values. These include:
Availability: All namespaces.
%SYSTEM.Util class
Includes the following class methods that you can use to convert or obtain information about date/time values:
Availability: All namespaces.
%Library.UTC class
Provides a set of class methods for working with %TimeStamp values. These are as follows:
Availability: All namespaces.
Reminder
The special variable $SYSTEM is bound to the %SYSTEM package. This means that (for ObjectScript) instead of ##class(%SYSTEM.class).method(), you can use $SYSTEM.class.method().
See Also