Archive for July, 2016

Informatica: Time-stamp issue

Posted: July 16, 2016 in Informatica

What is the difference between ‘YYYY-MM-DD HH24:MI:SS’ and ‘YYYY-MM-DD HH:MI:SS’

When source time-stamp is HH24 then Hour of day is (00-23)
When source time-stamp is HH12 or HH then Hour of day (01-12)

While conversion make sure you use the right time-stamp for conversion:

for example if your are trying to convert ‘2016-07-23 00:05:01′ as follows
TO_DATE(2016-07-23 00:05:01,’YYYY-MM-DD HH:MI:SS’) then it will through an error.

the right syntax is replace HH with HH24

Advertisements