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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s