Azure SQL数据库当前不认为澳大利亚东部时间在DST上 [英] Azure SQL Database currently doesn’t think that Eastern Australia is on DST
问题描述
我们正在做一些测试,发现我们的Azure SQL数据库存在时区问题,因为他们认为我们不在DST模式(UTC + 11)
We're just doing some testing and noticed that we had a timezone issue with our Azure SQL db's in that they don't think we're in DST mode (UTC+11)
选择
*
来自
sys time_zone_info 其中
名称
like
'%Austr%'
select
*
from
sys.time_zone_info
where
name
like
'%Austr%'
名称
name
current_utc_offset
current_utc_offset
is_currently_dst
is_currently_dst
W.澳大利亚标准时间
+ 08:00
0
岑.澳大利亚标准时间
+ 10:30
1
E.澳大利亚标准时间
+ 10:00
0
我们如何解决此问题?
推荐答案
我们正在做一些测试,发现我们的Azure SQL数据库存在时区问题,因为他们认为我们不在DST模式(UTC + 11)
We're just doing some testing and noticed that we had a timezone issue with our Azure SQL db's in that they don't think we're in DST mode (UTC+11)
Good day tcvlicensing,
所有Azure服务都使用UTC时区设置,而不管它们的物理位置.这也适用于Azure SQL数据库.
All Azure services use UTC time zone settings, regardless of their physical location. This also applies to Azure SQL Database.
这篇关于Azure SQL数据库当前不认为澳大利亚东部时间在DST上的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!