How to convert SQL date to an excel date format ?

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #160332

How to convert SQL date to an excel date format ?

qa-featured

Hello,

 

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.
 
Best Regards,
Parisi

Login/Register to Answer

Related Questions