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.
current itme stamp
Moderators: chulett, rschirm, roy
current itme stamp
somaraju
Re: current itme stamp
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
So you dont have to worry about the format its loading or storing internaly as long as the data is correct.
Regards
Om Prakash
somu_june wrote: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.
Re: current itme stamp
Hi Opdas,
Thanks for your help . Please can you tell me how to change the current timestamp to my desired string format.
Thanks,
Somaraju
Thanks for your help . Please can you tell me how to change the current timestamp to my desired string format.
Thanks,
Somaraju
somaraju