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 Amosbatto. I think you are right and I wil[…]

Pasar desde una PM table a Grid

Muchas gracias Amos, lo reviso y te cuento como me[…]

Loading issue

I spun up a test upgrade VM with a restored backup[…]

We are professionals and experts in what we do, fo[…]