I have a flat file source where I receive date in 'YYYY-MM-DD' format eg: 2015-09-08, however I need to convert this to timestamp format to load to my target DB2 table with timestamp column.
The target format would be as 'YYYY-MM-DD HH:MM:SS.NNNNNN' eg:2015-09-08 12:00:00.000000.
Please let me know how to acheive this. I have used to_date functions, but it is not working properly.
Kindly share your views.
Thanks in advance.