Datetime import/export issue
in [Using MS SQL Server]
|
Prev: Yellowfin Business Intelligence Release 4.0 Announced to Industry
Next: Odd character appended to data
From: t8ntboy on 2 Jul 2008 10:00 I am migrating data from one database to another. The process requires that I significantly modify the table and data structure. Therefore, I am exporting the data to a csv, making the adjustments and then importing it to the new table. One of the fields being migrated is a datetime field. When I export the data to a csv the seconds portion of the datatime entries revert to zero. For example, 1/18/2008 4:19:00 PM. What it needs to be is 1/18/2008 4:19:31 PM. Please advise how I can extract the data and maintain the seconds.
From: Plamen Ratchev on 2 Jul 2008 10:27 How do you export the data? I have used both BCP and the Import/Export wizard and they both export DATETIME values with milliseconds. Also, make sure to view the result CSV file in a text editor. If you open in Excel the default date format trims to the minute and you need to create custom formatting to see the seconds. HTH, Plamen Ratchev http://www.SQLStudio.com
From: t8ntboy on 2 Jul 2008 10:56 On Jul 2, 10:27 am, "Plamen Ratchev" <Pla...(a)SQLStudio.com> wrote: > How do you export the data? I have used both BCP and the Import/Export > wizard and they both export DATETIME values with milliseconds. > > Also, make sure to view the result CSV file in a text editor. If you open in > Excel the default date format trims to the minute and you need to create > custom formatting to see the seconds. > > HTH, > > Plamen Ratchevhttp://www.SQLStudio.com I am using the express version and exporting with a third part package (Teratrax). Suggestions for a better way with express?
From: Plamen Ratchev on 2 Jul 2008 11:14
I am not familiar with Teratrax. Since the BCP utility comes with SQL Server Express I would suggest to use it: http://msdn.microsoft.com/en-us/library/ms162802.aspx HTH, Plamen Ratchev http://www.SQLStudio.com |