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.