Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Timestamp returns GMT-04:00 in NOW() and CURRENT_TIMESTAMP() functions — Cloud Customer Connect
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
25
Views
4
Comments
edited May 22, 2019 7:36AM in Reporting and Analytics Taleo Enterprise 4 comments

Content

Hi,

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.

Register

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