You can use the Date and Time functions to manipulate date and time values, for example, you can create an output that consists of separate date and time inputs.
The available Date and Time functions are:
- ADD_DT_TIME
- ADD_TOD_TIME
- CONCAT_D_TOD
- DIVTIME
- DT_TO_DATE
- DT_TO_TOD
- EXTRACT_DT_YEAR
- EXTRACT_DT_MONTH
- EXTRACT_DT_DAY
- EXTRACT_DT_HOUR
- EXTRACT_DT_MINUTE
- EXTRACT_DT_SECOND
- EXTRACT_DT_MILLISECOND
- MULTIME
- NOW
- SUB_DATE_DATE
- SUB_DT_DT
- SUB_DT_TIME
- SUB_TOD_TIME
- SUB_TOD_TOD
- MAKE_DATE_AND_TIME
- MAKE_DATE
- MAKE_TIME_OF_DAY
- MAKE_TIME
- MAKE_DATE_AND_TIME_FROM_OPC
- MAKE_TIME_FROM_OPC
- UTC_TO_LOCAL
- LOCAL_TO_UTC