Survey Tabulation > Advanced expressions > UNICOM Intelligence function library > Date and time functions
 
Date and time functions
These functions operate on Date data only. An error occurs if you attempt to operate one of the functions in this group on data of any other type.
Function
Description
Reserved for future use.
Returns a date to which a specified time interval has been added.
Returns the time interval between two dates.
Returns the current local date in a particular time zone.
Returns the date from a date and time value.
Returns a specified part of a given date.
Returns a whole number between 1 and 31, inclusive, representing the day of the month.
Returns the index value of a time zone defined in the registry on the server.
Returns True if daylight-saving is currently in effect at the specified time in the specified time zone, or False if not.
Returns the name of the local time zone.
Returns the number of minutes to add to or subtract from UTC time to get the local time.
Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
Returns the UTC time that corresponds to a given local time.
Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
Returns a whole number between 1 and 12, inclusive, representing the month of the year.
Returns a string indicating the specified month.
Returns the current local date and time in a particular time zone.
Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
Sets the time zone for a program.
Returns the current local time in a particular time zone.
Returns the time from a date and time value.
Returns the local time that corresponds to a given UTC time.
Returns a string indicating the specified day of the week.
Returns a whole number representing the year.
See also
UNICOM Intelligence function library