UnixTime_To_DateTime2
Converts a Unix Time (Epoch) value to a datetime2 value.
- Free Function
- SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017
SELECT SQLHTTP.net.UnixTime_To_DateTime2 ( @UnixTime )
| Name | Type | Description |
|---|---|---|
| @UnixTime | numeric(20,7) | Unix time ( epoch ) value. |
datetime2
|
1 2 3 |
SELECT SQLHTTP.net.UnixTime_To_DateTime2(1511275921.8719774) |
|
1 2 3 4 |
--------------------- 2017-11-21 14:52:01.8719774 |