Data Transformation Engine Functions and Expressions Reference Guide

Chapter 2 - Using Functions List of Functions by Category
Functions and Expressions Reference Guide
45
Date/Time Functions
Function Description
ADDDAYS
Adds a specified number of days to a date
ADDHOURS
Returns a time value that is the result of adding a specified
number of hours to a given time
ADDMINUTES
Returns a time value that is the result of adding a specified
number of minutes to a given time
CURRENTDATE
Returns the system date
CURRENTDATETIME
Returns the system date and time
CURRENTTIME
Returns the system time
DATETONUMBER
Returns an integer that results from counting the days from
January 1, 1865, to the specified date
DATETOTEXT
Converts a date object or expression to a text item
FROMDATETIME
Converts a date/time item to a text string of a specified
format
MAX
Returns the maximum value from a series of number, date,
time, or text values
MIN
Returns the minimum value from a series of number, date,
time, or text values
NUMBERTODATE
Converts an integer to a date that is in CCYYMMDD
presentation. The integer is the number of days from
January 1, 1865, to the specified date
TEXTTODATE
Converts text that is in CCYYMMDD or YYMMDD
presentation to a date that looks like the text item
TEXTTOTIME
Converts an object defined as text to an object defined as
time
TIMETOTEXT
Converts a time object or expression to a text item
TODATETIME
Converts a text string of a specified format to a date/time