I am having some problem with exporting db2 time fields into a excel file as i am doing some of database mirgation.
first, i have exported db2 data into a excel file,and change the time format to read as hh:mm:ss, after that i import them into mysql database.
whem i export the time filed (hh:mm:ss) into a excel it become hh.mm.ss,hence, when i import them into mysql database only ss got imported.
You help will be much appricated!
Regards and thanks.
NY
Just a quick question, why are you exporting from db2 to excel and then to mysql.
Why not just export to a file then import that file to mysql.
This is more of an excel problem because it munges the field.
Just a quick question, why are you exporting from db2 to excel and then to mysql.
Why not just export to a file then import that file to mysql.
This is more of an excel problem because it munges the field.
actually, I exported the db2 into a txt file and open it using excel to conver the date and time column as db2 date format is dd-mm-yyyy whereas mysql yyyy-dd-mm.
Thanks and regards.
Use the modified by command for export. Try dateiso or timestampformat=. See this doc: http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0008303.htm
Use the modified by command for export. Try dateiso or timestampformat=. See this doc: http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0008303.htm