Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CSV and datetime fields
Message
From
05/06/2012 11:19:18
Greg Reichert
GLR Software
Providence, Rhode Island, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
CSV and datetime fields
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01545342
Message ID:
01545342
Views:
65
when I export from SSMS a result subset of data to a CSV (using Save As) all the datetime fields result in '00:00.000' . Is there a trick in getting SQL to output these correctly ('2012-06-05T12:32:45').

Never mind, I figured it out.
Greg Reichert
Next
Reply
Map
View

Click here to load this message in the networking platform