Timezone convertion in Python

I have been googling this issue for several times and each time it manages to get out of my mind within a few days. So I finally decided to just blog it, for share and for later references.