Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderator: amosbatto

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By HeshanKaru1994
#824580
Hi,
When I'm inserting to the database I'm converting to local time (UTC +5.30) and add,but when I'm retrieving from the database and display in the grid that value do not show that value(instead show without UTC +5.30)
By HeshanKaru1994
#824600
Hi, the problem is that when I insert the data to the db I use a similar way to convert the timezone but when I retrieve that same value from the db it shows according to a different time(in the db it saves correctly)
User avatar
By amosbatto
#824617
You can use a trigger like this:
Code: Select all
@@myDatetimeAdjusted = date("Y-m-d H:i:s",  strtotime(@@myDatetime, '+5 hours 30 minutes' ));
PS: If you are using ProcessMaker Enterprise Edition, remember that It has automatic datetime conversion to the time zone of the user.

Thanks for your reply, Press F12 in your web bro[…]

I created a new process to make it easier to look […]

Genial!!! gracias. :D

This is resolved. I took a punt on Amos' suggesti[…]