issue with data mismatch in timestamp
Posted: Tue May 26, 2009 6:04 am
Hi All,
I have developed a job in which my source dataset1 has postdate column in timestamp which has format of yyyy-mm-dd hh:mm:ss and dataset2 has transdate column which has format same format as dataset1.
but after joining these two datasets on Account_no, transdate format getting changed its in format dd-mmm-yyyy hh:mm:ss and values of hh:mm:ss are 00:00:00
Please help me to resolve this issue.
Regards
Prasoon Kumar
I have developed a job in which my source dataset1 has postdate column in timestamp which has format of yyyy-mm-dd hh:mm:ss and dataset2 has transdate column which has format same format as dataset1.
but after joining these two datasets on Account_no, transdate format getting changed its in format dd-mmm-yyyy hh:mm:ss and values of hh:mm:ss are 00:00:00
Please help me to resolve this issue.
Regards
Prasoon Kumar