How to convert the date format YYYYMMDDTHHMMSS in Informatica BDM. Yo may have this scenario in the inbound file where the timestamp will come with a string T along with the actual date & time. This is a valid timestamp in informatica and can be easily converted using to_date function. Let’s see the correct date format string for these type of date conversion.
sample input data: 20190417T091616
TO_DATE function: TO_DATE(emp_doj,’YYYYMMDD HH24MISS’)
output after conversion: 2019-04-17 09:16:16
Have any questions? or need help with this topic, please do reach out to me at kvtinformatica@gmail.com. Don’t forget to follow my Youtube channel and FB page, Lets stay connected and learn together.