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.
Date format
Moderators: chulett, rschirm, roy
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
Thanks for your suggestions
Kiran