New answers tagged sql-server-2008
0
votes
How to handle TimeZone properly in SQL Server?
Since Sql Server 2016 it introduced AT TIME ZONE which allows one convert a timeoffset which you can specify, such as
select getdate() at time zone 'Pacific Standard Time' as TimeInLA;
This blog ...
Top 50 recent answers are included
Related Tags
sql-server-2008 × 3893sql-server × 2354
sql-server-2008-r2 × 337
performance × 211
t-sql × 207
sql-server-2012 × 182
sql-server-2005 × 149
index × 127
replication × 111
backup × 106
stored-procedures × 95
restore × 93
database-design × 92
ssis × 88
security × 78
ssms × 72
query-performance × 66
permissions × 59
mirroring × 55
linked-server × 51
transaction-log × 49
ssrs × 44
trigger × 38
partitioning × 38
deadlock × 38