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

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})