Issue with timestamp

[gopskrish]

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_Server_Whale]

Hi,

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.

I didn't get that. "detect five hours from the time"????

Did you mean 'deduct'? Clarify.

[DSguru2B]

What is your source system? If it is a database then you can do the subtraction in the sql query itself. Most databases have built in timestamp manipulation functions.