March 20, 2013 at 2:36 pm
Good evening,
Please, my sql server Database has a table which contains this field: Date_Start(Datetime, Null). The format of the data in the table is yyyy/mm/dd. I have tried to export this table in Excel through SIS. Although I have used this fonction Convert(Date,Date_Start,103) the date format is still yyyy/mm/dd instead of dd/mm/yyyy in my Excel File. please what can I do to obtain the correct date format dd/mm/aaaa in my excel file after data exportation from my table through SIS?
Thanks in advance.
March 20, 2013 at 2:46 pm
Converting a date back to a date will end up displaying the date in the same default format.
Try:
Convert(varchar(20),Date_Start,103)
March 21, 2013 at 2:48 am
It's Ok now. Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply