Forum Discussion
ElliotP
Post Prodigy
Post ProdigyUTC to AEST
Morning, The DateTime column in my sql table is in UTC time, but I would like this column to be in the AEST (-10 or -11) timezone. I've read quite a lot through the forums and all of the solution...
You can use the table and function from my post as illustrated in this video:
MarcelBeug
Community Champion
Community Championv-caliao-msft your solution won't work in this case as it doesn't take into account Daylight Saving Time (DST) switches.
ElliotPPost Prodigy
Post ProdigyThis is the issue we are working to solve.
I've seen a complicated potential solution on radacad (I can find the link if you haven't seen it before); but it relies upon working with an external API which seems a tad overkill.