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
Is this related to your question?? , Anyways you can directly subtract the two date times or you can use functions like tointervalds() or calwordays()