Re: Datetime data type problem with dbimport.

Posted in 2004

Topics: Data Types & Schema Design, Migration, Import/Export & Data Conversion

scottishpoet — 3 May 2004 10:29:30 -0700 — source: Usenet: comp.databases.informix

I think this is related to GL_DATETIME unloading in the specified format but not loading in from the specified format. Try unloading and reloading the data with GL_DATETIME unset in both scenarios.

↪ replying to scottishpoet

Jonathan Leffler — Tue, 04 May 2004 04:30:53 GMT — source: Usenet: comp.databases.informix

scottishpoet wrote: > I think this is related to GL_DATETIME unloading in the specified > format but not loading in from the specified format. > > Try unloading and reloading the data with GL_DATETIME unset in both > scenarios. That's the obvious workaround - I should have mentioned it. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Glossary

dbexport / dbimport