How to programmatically get my pc timezone offset RRS feed

  • Question

  • how can i know and pass my pc timezone offset which i can pass to sql server store proc

    see my bit of sql server code

    SELECT sysdatetimeoffset(), switchoffset(sysdatetimeoffset(), '-05:00')

    here -05:00 is hard coded which is timezone offset. how to get it by c# 

    the above sql convert one timezone to other timezone based on offset value -05:00


    Saturday, February 22, 2020 7:25 PM