<div>
Convert? Can your rephrase your question?<br />
<br />
Depending on the use-case use the appropriate data type: &nbsp;<a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetimeoffset-transact-sql?view=sql-server-2017" rel="ugc">DATETIMEOFFSET</a>.<br />
Using the <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetimeoffset-transact-sql?view=sql-server-2017" rel="ugc">SYSDATETIMEOFFSET()</a> function to get the current value.
</div>


<div>
I think this is what you are looking fo 
<pre><code class="code-1 nolinks" id="code-20-42700517-1"><span> SELECT SYSDATETIMEOFFSET();  </span>
</code></pre>
See : <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetimeoffset-transact-sql?view=sql-server-2017" rel="ugc">https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetimeoffset-transact-sql?view=sql-server-2017</a><br />
<br />
<br />
Example, my machine is Sydney AUS - just gone to daylight saving... <br />
<br />
&nbsp;SELECT SYSDATETIMEOFFSET(); &nbsp;<br />
<br />
&nbsp;returns : 2018-10-08 23:51:01.5642041 +11:00<br />
<br />
<br />
The other method is to use &quot;AT TIME ZONE&quot; see : <a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-2017" rel="ugc">https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-2017</a>&nbsp; But your SQL Server needs to be 2016<br />
<br />
example : <br />
<br />
SEECT convert(varchar(30), getdate() at time zone 'AUS Eastern Standard Time',126)<br />
<br />
returns : 2018-10-08T23:51:01.567+11<wbr />:00<br />
<br />
And almost forgot one of my favourites - FORMAT() - since SQL2012 :<br />
<br />
select format(getdate(),'yyyy-MM-<wbr />ddTHH:mm:s<wbr />szzz')<br />
<br />
While my examples above use GETDATE() - you would use your date column.
</div>


GNiessen

<div>
Unfortunately the SYSDATETIMEOFFSET() is not the format I need. &nbsp;And since we support Daylight Savings Time here, our offset changes from -05:00 to -06:00. &nbsp;I was looking for a solution where I would not have to write my own function to manage the format.
</div>


<div>
It seems you would need more complex expression:<br />
<br />
SELECT SYSDATETIMEOFFSET(), LEFT(CONVERT(varchar(50), SYSDATETIMEOFFSET()), 10)+'T'+SUBSTRING(CONVERT(<wbr />varchar(50<wbr />), SYSDATETIMEOFFSET()), 12, 8)+RIGHT(CONVERT(varchar(5<wbr />0), SYSDATETIMEOFFSET()), 6)
</div>


<div>
What's the problem?<br />
<br />
Currently its 2018-10-08 16:16:32.5182605 +02:00 here in Germany. The CEST is coded in the +02:00. In three weeks it will be 2018-10-08 15:16:32.5182605 +01:00. Then the CET is in the +01:00.<br />
<br />

<blockquote>
Unfortunately the SYSDATETIMEOFFSET() is not the format I need.
</blockquote>
Can you imagine that more details would be helpful?
</div>


<div>
Did you see all my post above ?<br />
<br />
You dont have to write your own routine.<br />
<br />
You can use (from above) the FORMAT() command : <br />
<br />
select format(getdate(),'yyyy-MM-<wbr />ddTHH:mm:s<wbr />szzz')<br />
<br />
<br />
And there were other suggestions above as well (depends on what version of SQL Server you are running)<br />
<br />
<br />
<br />
BTW, what version of SQL are you using ?
</div>


<div>
btw, conversion for consumers is best done in the front-end..
</div>


<div>
@ste5an: &nbsp;LOL<br />
Currently its 2018-10-08 &nbsp;in Germany … in three weeks it will be 2018-10-08 ... What date will be in Germany in three years?<br />
<br />
@Mark Wills:<br />
Yes, if GNiessen uses SQL 2012 and higher then it should work (updated)<br />
The question is what should be the time part displayed? &nbsp;Local time or UTC? &nbsp;The standard is Local time + offset. <br />
<br />
BUT if this time format should be calculated from simple datetime column which contains just local time then you have uncertainty during the 1 hour period when Daylight saving changes to normal time.
</div>


<div>
Have you tried this where expression is the datetime field <br />
<br />
TODATETIMEOFFSET ( expression , time_zone ) &nbsp;<br />
<br />
mlmcc
</div>


<div>
I do need to be able to pass in a datetime value. &nbsp;Say for example:<br />
MyDT = '2018-10-01 08:30:00'<br />
And get the appropriate format back: '2018-10-01T08:30:00-05:00<wbr />' and also supprt the daylight saving change so that '2018-12-24 08:00' comes back as '2018-12-24T08:00:00-0600'<wbr />
</div>


<div>
Please again: more details please.<br />
<br />
If we talk about a SQL Server backend, then use the DATETIMEOFFSET data type and store the correct value. <br />
<br />
Cause a function date to date+offset is not trivial, cause it is prone to error. Because you need to take into account, that you cannot for sure tell, what time zone (offset) was used (meant) when the a date was entered. E.g. what should &nbsp;be the output for 2018-10-28 02:30?
</div>


<div>
I am using using SQL Server 2014 and in the Central US timezone. &nbsp;I don't want to have to figure out if it is CST or CDT, or -5 or -6. &nbsp;I figure the system can figure that out if I ask nicely. &nbsp;:-)
</div>


<div>
SYSDATETIMEOFFSET() only returns the current time in the appropriate offset. &nbsp;So if I am needing the date time formatted for a record from 6 months ago, it is not directly useful.
</div>


<div>
@GNiessen: This is achievable by the FORMAT() function (see Mark Wills posts) except all cases which are falling into the one hour after the Daylight saving ends.<br />
<br />
It seems you are using CDT time now.<br />
What offset do you use for the local time 2018-11-04 01:30:00? &nbsp;Such local time is ambiguous when you don't know whether it falls into CDT or CST.<br />
Opposite problem does not happen hopefully. I mean 1 hour when the CST time changes to CDT which could produce non-existing local time.
</div>


<div>
@pcelba: Yes, I could use the Format() recommended by Mark Wills, if I knew how to get the local offset for the DateTime being formatted. &nbsp;How can I find if the Offset at that date time should be -5 or -6 for our timezone?
</div>


<div>
Thanks everyone for the quick response and various recommendations. &nbsp;I picked the solution that looks the simplest to maintain on my end.
</div>


<div>
Just be aware of the above function accuracy. It does not handle properly the times which belong to the transition period between Daylight saving and Standard time. If you want to be accurate then you should check whether your data contain ambiguous local times or (less possibly) non-existing times.<br />
<br />
Ambiguous are e.g. local times between 2018-11-04 01:00 and 2018-11-04 02:00. FORMAT() function handles them as Standard time whereas it could also be Daylight saving time.
</div>


<div>
<div class="content wysiwyg-content">
I need to convert a Date Time from our sql server to a date time format that includes UTC offset like &quot;2018-10-05<b>T</b>12:00:00-05:00&quot; that supports daylight savings time. &nbsp;I am sure there is a function to do this, but I can't seem to ask google the right question to find it.
</div>
</div>


I need to convert a Date Time from our sql server to a date time format that includes UTC offset like "2018-10-05T12:00:00-05:00" that supports daylight savings time.  I am sure there is a function to do this, but I can't seem to ask google the right question to find it.

Convert datetime to UTC string format

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.

Delphi

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.