Date format

kiran259 · Post by **kiran259** » Mon May 19, 2008 7:45 am

Hi,
My input file date format is of type eg:17-May-2008.The database I am using is DB2 and its date format is yyyy-mm-dd.Can I have a solution for loading this type of input file format in terms of DB2 date?

Thanks in Advance
Kiran.

ArndW · Post by **ArndW** » Mon May 19, 2008 8:59 am

If you are using the data type of "Date" and correctly convert in the source string into that format then you should have no worries when writing that to DB2.

kiran259 · Post by **kiran259** » Tue May 20, 2008 3:13 am

Thank you..In fact,my input file timestamp is 11-May-2008 22:21:00.So I have customized the timestamp format to %dd-%mmm-%yyyy and I got the timestamp output which is compatible to DB2.Previously Iam using varchar data type to load this format and hence I have a problem.

Thanks for your suggestions
Kiran