Skip to Content

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

Date Format

Hello All,

i want to create a query from the OCRD Database.

the create Date format is DD/MM/YYYY actually. is it possible to get it back in YYYYMMDD?

i tried allready the FORMAT and TO_CHAR function but it didn't work in the SQL Statemant??

Thank you and best regards

Serkan

Former Member
Former Member replied

Hello Serkan,

You may use Cast or Convert to do the job. Convert is the simplest way such as: Convert(varchar(8), GetDate(), 112).

If you need query result for DTW upload, better changing date format under Excel. That would be much easier.

Thanks,

Gordon

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