SAP Knowledge Base Article - Preview

1831775 - How to convert string date and time values with AM/PM to 24hr datetime format? - Data Services

Symptom

  • Convert a string date and time containing AM and PM to 24hr datetime format
  • Input value is a string such as '3/4/2018 12:00:00 AM' that needs to be converted to datetime datatype
  • Database datetime datatype does not support AM/PM
  • to_date function does not have conversion code for AM\PM for 12 hour date format


Read more...

Environment

SAP Data Services

Product

SAP Data Services 4.0

Keywords

KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.