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
priyadharshinis746840 said:I'm using view to fetch data and show in front-end
Can you elaborate this?? Are you using query record/ entity or any SQL commands?
By default, Appian stores time values in ++GMT in database , whenever you query it and show it in grids it will convert into user locale. you don't have to do anything