Avatar of Bob Schneider
Bob Schneider
Flag for United States of America

asked on 

Converting UTC to Local Time

I have a database value that has a time-of-day value in seconds that was entered as local time.  It needs to be compared to the current UTC time.  It is being used to display a running time from when a race started (the stored value as local time) to the current time (UTC) in seconds, updating each second.  I am using classic asp and microsoft sql server.  Is there a script that would convert the stored local time to UTC?
ASPMicrosoft SQL Server

Avatar of undefined
Last Comment
Dustin Saunders

8/22/2022 - Mon