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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy