How to convert SQL date to an excel date format ?

Asked By Conley Pamela 0 points N/A Posted 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.

• Status: Open
• Question Views: 1756
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Parisi Petrusic 0 points N/A #160332

How to convert SQL date to an excel date format ?

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

• Vote Up 0 Vote Down

• Posted on - 02/13/2013
• Question Category: MS SQL Server