Return
-
Title
How to format date values of table columns in export wizard? -
Description
User needs to export tables containing date values and import this data to DB2. Date values are not accepted in DB2 due to the format export. How does one format date values of table columns in export wizard?
-
Resolution
In Export wizard, use Query option to enter a query statement in order to export table data.
Modify query statement to format date column as desired using CONVERT function as such:
SELECT <column name1>, <column name2>, CONVERT(date,<column name3>,3) FROM <table name>
More information about TSQL CONVERT function syntax can found here:
http://msdn.microsoft.com/en-us/library/ms187928.aspx