ToDate DateTime (DateTime)

Name	ToDate with Time
Syntax	ToDate (Integer year, Integer month, Integer day, Integer hour, Integer minute, Integer second)
Purpose	To create a new date using specified year, month, day, hour, minute, and second.
Description	Returns the newly created date if the parameters evaluate to a valid date. Otherwise returns null.
Return Type	DateTime
Parameters	year [System.Int64] – Year including the century month [System.Int64] – Month (1-12) day [System.Int64] – Day (1-31) hour [System.Int64] – Hour (0-23) minute [System.Int64] – Minute (0-59) second [System.Int64] – Second (0-59)

Example

In this example, we will pass valid integer values to the function transformation object using a Variables object.

Where,

year = 2020

month = 01

day = 30

hour = 4

minute = 30

second = 10

In the output window, you can see that the provided values have been converted into a DateTime value.