How to convert Informatica date format YYYYMMDDTHHMMSS

by kvt - Comment is Closed

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

sample input file having date as YYYYMMDDTHHMMSS
To_date function with correct date format string

Successfully converted the filed to a valid date time format

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.

Related Posts: