Year - Month - Day - Hour - Minute - Second Heater, extracting parts of a date / time field
Using the Year, Month, Day, Hour, Minute and Second Heaters you can extract the individual components in date and/or time fields. The Heaters all have one input (a Date / Time) and one output (data type INT, which is always a whole number)
Year (Y) gives the year number (4 digits) from a date
Month (Mo) extracts the month number from a date
Day (D) reads out the day number from a date
Hour (H) delivers the hour from a time
Minute (Mi) extracts the minutes from a time
Second (S) reads out the seconds from a time
Note: If the incoming value cannot be converted into a DateTime data type according to the format configuration of the WRITE Adapter, an empty value of NULL (undefined) is returned. In addition, a warning message is output in the DoWork execution popup or the batch shell output stream.
Please also refer to the general information on the use of Heaters (functions)