主页 / 问题 / 1297345
Accepted
Yuriy Tigiev
Asked:2022-06-21 03:53:37 +0000 UTC2022-06-21 03:53:37 +0000 UTC

如何将作为字符串给出的时间从时区转换为 TSQL 中的日期时间？

  • 772

如何将作为字符串给出的时间从时区转换为 TSQL 中的日期时间？

SELECT CONVERT(datetime, '2006-12-12T23:45:12.000-08:00', 127)

Conversion failed when converting date and/or time from character string.
sql

1 个回答

  1. Best Answer

    请尝试以下解决方案。

    SQL Server 2016 及更高版本。

    SQL

    -- DDL and sample data population, start
DECLARE @var DATETIMEOFFSET(3) = '2006-12-12T23:45:12.000-08:00';
-- DDL and sample data population, end

SELECT @var AS [Before]
    , CAST(@var AS DATETIME) AS [After]
    , @var AT TIME ZONE 'Russian Standard Time' AS [Local]
    , CAST(@var AT TIME ZONE 'Russian Standard Time' AS DATETIME) AS [LocalDateTime];

SELECT * FROM sys.time_zone_info
ORDER BY name;

SELECT @@VERSION;
    • 1

相关问题