<div>
converting smalldatetime to date format is the way I did. 
format cells on the column as a date format that shows the days-months-years, it works.
</div>

converting smalldatetime to date format is the way I did.
format cells on the column as a date format that shows the days-months-years, it works.

<div>
<div class="content wysiwyg-content">
when I copied the following query result to excel, they showed as 00:00.0 
 
2011-04-20 00:00:00.000 
2006-08-17 00:00:00.000 
2011-01-10 00:00:00.000 
2000-12-13 00:00:00.000 
2010-11-04 00:00:00.000 
2003-05-28 00:00:00.000 
2011-05-17 00:00:00.000 
2005-05-02 00:00:00.000 
2005-07-25 00:00:00.000 
2010-04-30 00:00:00.000 
 
 
in excel: 
 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
00:00.0 
 
I can convert smalldatetime format to date format, but is there any easy way to just copy over the smalldatetime date to the excel? 
 
thanks,
</div>
</div>

when I copied the following query result to excel, they showed as 00:00.0

2011-04-20 00:00:00.000
2006-08-17 00:00:00.000
2011-01-10 00:00:00.000
2000-12-13 00:00:00.000
2010-11-04 00:00:00.000
2003-05-28 00:00:00.000
2011-05-17 00:00:00.000
2005-05-02 00:00:00.000
2005-07-25 00:00:00.000
2010-04-30 00:00:00.000


in excel:

00:00.0
00:00.0
00:00.0
00:00.0
00:00.0
00:00.0
00:00.0
00:00.0
00:00.0
00:00.0

I can convert smalldatetime format to date format, but is there any easy way to just copy over the smalldatetime date to the excel?

thanks,

copy smalldatetime date from query result to excel

A printer is a peripheral which makes a persistent human readable representation of graphics or text on paper or similar physical media. Traditional printers are being used more for special purposes, like printing photographs or artwork, and are no longer a must-have peripheral; 3D printing has become an area of intense interest, allowing the creation of physical objects. An image scanner is a device that optically scans images, printed text, handwriting, or an object, and converts it to a digital image. Hand-held scanners, where the device is moved by hand, have evolved from text scanning "wands" to 3D scanners used for industrial design, reverse engineering, test and measurement, orthotics, gaming and other applications.

Printers and Scanners

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.