BST – Converting UTC time to local time

This is my take at sorting out the issue of storing UTC dates but needing to display the time during british summer time correctly. I found a few solutions with crazy lookup tables so this bit of SQL should be a lot quicker! I just need to return the time as a string but obviously you can change that to whatever suits your needs.

Leave a Reply

Your email address will not be published.