MySQL day function gives incorrect value

The DT column is in UTC. I use table view to see the results, then proper visualizations.

The issue is solved. Looks like even though the sql server in Azure has Eastern timezone as shown in the picture in the post, it’s following my browser i.e. my laptop’s timezone utc+6.

2 Likes