How to convert datetime from PST to ISO and Hawaii to ISO using OIC
I am getting the value for a date field from source file in the PST format or Hawaii format but i need to convert it to ISO format to map it to the filed that will be dumping into sql table. How can I achieve this?
Input from source file: 2/4/2025 7:58 (M/D/YYYY HH:MI)
Expected Conversion: 2025-02-04T07:58:00 (YYYY-MM-DDTHH:MI:SS)
Note: if YEAR or MONTH or DATE or HOUR or MINUTE or SCONDS values are coming in a single digit then it should be preceeded with 0(zero) ahead of the digit while converting. For example in above scenario Month,Day,Hour values are converted from 2,4,7 to 02,04,07.