You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Timestamp returns GMT-04:00 in NOW() and CURRENT_TIMESTAMP() functions

Received Response
edited Dec 13, 2022 7:09AM in Taleo Enterprise 4 comments



We are on GMT+04:00 timezone. We are getting all the recorded column values in GMT+04:00. But when I am trying to get the functions NOW() and CURRENT_TIMESTAMP, it is returning GMT-04:00 value. I tried with column properties, it doesn't work.

Basically I am trying to get the time difference between "current status date" and current time. I tried with below functions. Doesn't work. Kindly help.

1. TIMESTAMPDIFF(SQL_TSI_HOUR, "Submission CSW Status - Current"."Current Status Start Date",CURRENT_TIMESTAMP) 

this gives me a difference of "-8" from actual value

2. TIMESTAMPDIFF(SQL_TSI_HOUR, "Submission CSW Status - Current"."Current Status Start Date",@{system.currentTime})

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!