Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
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