Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
  • Home
  • Documentation
  • Year - Month - Day - Hour - Minute - Second Heater, extracting parts of a date / time field

Year - Month - Day - Hour - Minute - Second Heater, extracting parts of a date / time field

Common Date/Time HeatersUsing 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)