Skip to main content
simply more productive

The Data Specialist

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.
Flowheater Chart

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)

FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.