Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

incorrect date conversion

hi all,

i am trying to convert a string to a date, please help me on this.

i tried these options:

to_date('01/05/2015 10:00 PM','mm/dd/yyyy hh12:mi ') -> blank output

to_date('01/05/2015 10:00 PM','mm/dd/yyyy hh:mi ') -> wrong output  [output is 2015.01.05 10:00, but expected was 2015.01.05 22:00]

to_date('01/05/2015 10:00 PM','mm/dd/yyyy hh12:mi aa ') ->blank output

Former Member
Former Member replied

Hi Swetha,

Since Data Services only supports 24 Hour format.

Please check the below note:

SAP Note 1831775 - to_date function does nothave conversion code for AM\PM for 12 hour date format.


V Srinivasan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question