Nilesh Wattamwar wrote:I am trying to export the data into CSV using openCSv framework.Database is Universe Db.CSV generates fine with "$" as separator.But when we tried to load the same csv data into IBM DB2 database it is failing because of incompatible date format(i.e DD-MMM-YYYY).While IBM DB2 doesnt support the mentioned date format.
"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here
Nilesh Wattamwar wrote:first two steps are fine.for 3rd step how can convert the date on my own? can you please explain,it will be better if provided the code for the same.
"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here
Nilesh Wattamwar wrote:true..
but i found similar option when i googled it...but nothing is working more over i have only one option to access the universe db i.e. from java ..![]()
![]()
it will be very helpful i get some functions to convert the date format in universe database.
Dave Tolls wrote:But my preference will always be to get the data out of the DB in the format you want. It's a good habit since it tends to be quicker, often by quite some margin, than crunching the data row by row (or slow by slow)...
"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here
It's never done THAT before. Explain it to me tiny ad:
New web page for Paul's Rocket Mass Heaters movies
https://coderanch.com/t/785239/web-page-Paul-Rocket-Mass
|