in my database i have time in 24 hours format for example "8:00". when i create a query for this datetime what i receive is a result with four hours difference how can i achieve to get it in the same time zone as the database
Discussion posts and replies are publicly visible
Appian considers the data in the DB to be in UTC. I then will transform the data to your time zone. Important: This happens only in the presentation layer. The value itself is still UTC.
ALWAYS save time in the database as UTC/GMT rather than your local time as once you start messing with time and timezones you're in for a bad time. Let Appian do all the hard work for you. If you need to force particular scenarios then check out the following functions. Also, check out Tom Scott's rant on timezones HERE
https://docs.appian.com/suite/help/22.1/fnc_date_and_time_gmt.html
https://docs.appian.com/suite/help/22.1/fnc_date_and_time_timezone.html
https://docs.appian.com/suite/help/22.1/fnc_date_and_time_local.html
But my strong suggestion would be to avoid at all costs messing with time. Work it where you can that you save into the database UTC/GMT value and let Appian convert it in the front end.
Thanks you all guys