Skip to Content

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

Need to change the date format

Hi,

I need to load the data from MS SQL through DB Connect. the source field date format is 2010-01-20 00:00 ( this is MSSQL data type - "smalldatetime") and required query format is 06-Feb-10.

So where we can change the format. in the query level, or at the info provider level.

1. If at the info provider level Please provide me the steps.

2. If at the query level. please provide me the steps to do.

what is the best option?

thanks in advance

Former Member
Not what you were looking for? View more on this topic or Ask a question