issue with data mismatch in timestamp

prasson_ibm · Post by **prasson_ibm** » 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

ArndW · Post by **ArndW** » Tue May 26, 2009 6:24 am

What is the data type? The display format is independant of how the data is actually stored; this is what I am assuming your problem is. What tool are you using to display your data?

prasson_ibm · Post by **prasson_ibm** » Tue May 26, 2009 11:17 pm

ArndW wrote:What is the data type? The display format is independant of how the data is actually stored; this is what I am assuming your problem is. What tool are you using to display your data? ...

First i have taken the datatype as Timestamp,but the result was worng

then i changed with varchar but still same problem....and i m using dataset to store the data and display

ArndW · Post by **ArndW** » Wed May 27, 2009 12:57 am

You have 2 issues, one is just that the date is being displayed in another format, and that has nothing to do with the contents. The other is that you seem to be losing the time portion. This could be either display format related or be happening when you modify or fill the column. How are you doing this? You mentioned a "join" but not how the transdate column is derived.