current itme stamp

[somu_june]

Hi,

Iam using current timestamp for loading a UPDATE_TIMESTAMP columm to DB2 table it was loading it as Apr 10,2006 12 :09 : 56 AM 000000 but I want to load it as 20060410120956000000. How t oachieve this. Please correct me if Iam wrong I think DB2 takes current timestamp as Apr 10,2006 12 :09 : 56 AM 000000 by default . Can I load it as I mentioned above and how to achieve that . Please some one help me .


Thanks
Somaraju.

[opdas]

Assuming that your target table is DB2, and you are mapping UPDATE_TIMESTAMP as current Date() in transformer, its Datastage which converts the timestamp into DB2's readable format.When you view the data , it shows the data in the format you ave mentioned. So when you fire a select querry on the concerend table you can change the timestamp to your desired string format to view.

So you dont have to worry about the format its loading or storing internaly as long as the data is correct.

Regards
Om Prakash

Hi,

Iam using current timestamp for loading a UPDATE_TIMESTAMP columm to DB2 table it was loading it as Apr 10,2006 12 :09 : 56 AM 000000 but I want to load it as 20060410120956000000. How t oachieve this. Please correct me if Iam wrong I think DB2 takes current timestamp as Apr 10,2006 12 :09 : 56 AM 000000 by default . Can I load it as I mentioned above and how to achieve that . Please some one help me .


Thanks
Somaraju.

[somu_june]

Hi Opdas,

Thanks for your help . Please can you tell me how to change the current timestamp to my desired string format.




Thanks,
Somaraju

[opdas]

Try using timestamo to char function in DB2 in the sql ......

[kumar_s]

TimestampToString Return the string representation of the given timestamp - from Datasetage.

[DSguru2B]

Btw why do you want to do that even?