Cheatsheet - Time related query tricks

A cheat sheet for me to collect the wisdom in query date time.... (and this is on-going updated when I find other clever method over time)

Convert UTC time into local time