Issue with timestamp
Posted: Wed Jan 10, 2007 9:07 am
Hi,
I am using Parallel Job and I want to insert timestamp value into Sybase database.
My timestamp value should be currentdatetime() - 5 (5 hours).
Since we are loading the value from our dev server which is using GMT
But our other server which is using EST is picking up these records based on Update date time. So, when i load from our dev server i should detect five hours from the time, i load my jobs.
Please throw some light if anyone of you have some solution.
Thanks in advance.
gop
I am using Parallel Job and I want to insert timestamp value into Sybase database.
My timestamp value should be currentdatetime() - 5 (5 hours).
Since we are loading the value from our dev server which is using GMT
But our other server which is using EST is picking up these records based on Update date time. So, when i load from our dev server i should detect five hours from the time, i load my jobs.
Please throw some light if anyone of you have some solution.
Thanks in advance.
gop