Date/Time format is changing will importing through Transform Map

Anubhav Ritolia
Kilo Contributor

Hi All,

When I am trying to import value for Date/Time field, and it the hours is 12, it is automatically converting it to 00. But it is working properly when it is 13Hr or even 23Hr.

For example, If I import 2020-03-05 12:50:40 in system it comes as 2020-03-05 00:50:40.

But, If I import 2020-03-05 13:50:40 in system it comes as 2020-03-05 13:50:40 properly. 

Also there is no AM or PM mentioned. What can be the issues?

This is happening for all Date/Time fields present in my table.