<div>
Note...all I needs is hh:mm:ss, no date values
</div>

<div>
<ul><li>What version of SQL are you using?</li><li>Does the conversion need to be permanent (i.e. is the app storing UTC now) or just when queried?</li><li>Is the local time the SQL server's local time zone for everyone or is the time specific to users in various different timezones?<ul><li>If the latter, are the user's local time zones stored somewhere?</li></ul></li></ul> If you just need to do a conversion from the server's local timezone, all you need to know is the UTC offset and just apply that to the dates. &nbsp;Daylight Savings gets in the way but you can get data from sys.time_zone_info for this. &nbsp;For example if the local server were Central Standard Time:<pre><code class="code-1 nolinks" id="code-20-43289446-1">DECLARE @offset INT, @utcOffset INT = 6
SET @offset = (SELECT is_currently_dst FROM sys.time_zone_info WHERE [name] = 'Central Standard Time')
SET @utcOffset = @utcOffset - @offset

SELECT @utcOffset
SELECT GETDATE()
SELECT DATEADD(HH, @utcOffset, GETDATE())
</code></pre>which gives <pre><code class="code-1 nolinks" id="code-20-43289446-2">5
2021-05-17 12:32:39.650
2021-05-17 17:32:39.650
</code></pre>sys.time_zone_info has all the offsets and dst info, but if you can answer the above questions and provide sample data in your schema I can give a more complete answer.&nbsp; SQL 2016+ also has some new TIME ZONE functionality which is why I ask the version.
</div>

<div>
Thanks for the response: 
1) SQL Server 15.0.2000 
2) Just when queried 
3) The time is specific to different users who are potentially in different time zones. &nbsp;Local time zones are not stored. 
 
Here is how I currently get the time of day the race started in seconds: 
 

<pre><code class="code-10 nolinks" id="code-20-43289457-1"> 'get event start time and start timer
 sngStartTime = &quot;00:00:00&quot;
 Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;)
 sql = &quot;SELECT StartTime FROM RFIDSettings WHERE EventID = &quot; &amp; lEventID
 rs.Open sql, conn, 1, 2
 If rs.RecordCount &gt; 0 Then sngStartTime = ConvertToSeconds(rs(0).Value)
 rs.Close
 Set rs = Nothing

 Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;)
 sql = &quot;SELECT RaceID, RaceName, StartTime FROM RaceData WHERE EventID = &quot; &amp; lEventID
 rs.Open sql, conn, 1, 2
 If rs.RecordCount &gt; 0 Then
 Races = rs.GetRows()
 Else
 ReDim Races(2, 0)
 End If
 rs.Close
 Set rs = Nothing

 If CLng(lRaceID) &gt; 0 Then
 lngRaceStart = 0 'in case start has not been submitted yet

 Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;)
 sql = &quot;SELECT RaceDelay FROM RaceData WHERE RaceID = &quot; &amp; lRaceID
 rs.Open sql, conn, 1, 2
 If rs.RecordCount &gt; 0 Then lngRaceStart = ConvertToSeconds(rs(0).Value) + sngStartTime
 rs.Close
 Set rs = Nothing
 End If
</code></pre>
 
lngRaceStart is the value in seconds that needs to be converted to UTC
</div>

<div>
Is ConvertToSeconds returning the number of seconds in the day so far? &nbsp;So if the race started at 8:00 AM it would be 8 * 60 * 60 (28,880 seconds)? &nbsp;And then you need to see what the equivalent time in seconds is for UTC? Without knowing the time zone for each race, you can't really convert them to UTC since we don't know the offset to apply to each locale. &nbsp;If you were able to add that as a profile setting for each person recording the race then you could easily do it. When does the data get inserted into the database?<ul><li>If the time stamp is not user defined and instead the time when someone clicks the 'start race' button, etc. then just add a new column and insert your own UTC timestamp with the insertion.</li><li>If there is a meaningful gap in the time the data is inserted and the race starts (seconds or minutes, etc) you can insert a UTC time stamp then extrapolate the time zone offset from the difference in the user submitted time and your UTC time stamp and just apply that offset to the original time entry.</li></ul>
</div>

<div>
Lets start with central time. &nbsp;We almost always work in that time zone and can choose not to do this when not in that zone. &nbsp;Is there always a 5 hour offset from UTC to CST (daylight savings not withstanding)? &nbsp;If the answer is yesn can I just add 5 hours fto the stored (local) time?
</div>

Owner

Bob Schneider

<div>
<div class="content wysiwyg-content fr-view">
I have a database value that has a time-of-day value in seconds that was entered as local time. &nbsp;It needs to be compared to the current UTC time. &nbsp;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. &nbsp;I am using classic asp and microsoft sql server. &nbsp;Is there a script that would convert the stored local time to UTC?
</div>
</div>


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?

Converting UTC to Local Time

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.