N/APosted on - 02/05/2013
How to convert the date on a sql server to an excel date format ? I'm confused with the codes. Usually we use the Feb 5, 2013 date format. I'm working on an sql server. How to convert sql date to excel format ? Please suggest me the codes.
How to convert SQL date to an excel date format ?
There are two good options: You could use either SELECT clng(Date) or SELECT int(Date) in SQL. But in Excel please make sure that you do not format the column as anything other than Date. Then save the format. Do it for as many rows or columns you need in Excel. Otherwise, you will run into problems.
Hope it helps.