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
About Parisi Petrusic
Questions
2
Answers
100
Best Answers
12

How to code an animated flash mouse bar ?

Previous

Need instructions on silent installation of yahoo messenger.

Next

Related Questions