I am storing the values to sql in gmt format ,when I fetch
The data back and show it in grid Iam changing to clients timezone but it stores in db as gmt while querying and showing in grid making difference in the time
I checked separately but the issue is in sql we need to conver to local timezone and use it.Is there any way,please suggest
I'm using view to fetch data and show in front-end
Discussion posts and replies are publicly visible
Not sure what you want to achieve, but in this post, I describe how time works in Appian.
https://appian.rocks/2023/02/13/working-with-time-in-appian/