Need to change the date format
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