In SQL Server run the following query: "select * from sys.time_zone_info". This is the list of time zones your server supports. In a table store the appropriate time zone for your purpose in a sysname typed (nvarchar(128) not null) column. To retrieve the time zone appropriate date and time run the following query: "select sysdatetimeoffset() at time zone 'Hawaiian Standard Time'". The query returns the current Hawaiian standard time as datetimeoffset column type (which is super precise). To return just the time zone appropriate date run: "select cast(sysdatetimeoffset() at time zone 'Eastern Standard Time' as date)".
![Working with date and time data in .NET [eng] / Jon Skeet](http://i.ytimg.com/vi/zbfsGMMt-QI/mqdefault.jpg)
"Dates and times aren't that hard.. In fact they're so easy it will only take just over an hour to explain how easy they are."
and in the end, just use the format with the timezone offset
In SQL Server run the following query: "select * from sys.time_zone_info". This is the list of time zones your server supports. In a table store the appropriate time zone for your purpose in a sysname typed (nvarchar(128) not null) column. To retrieve the time zone appropriate date and time run the following query: "select sysdatetimeoffset() at time zone 'Hawaiian Standard Time'". The query returns the current Hawaiian standard time as datetimeoffset column type (which is super precise). To return just the time zone appropriate date run: "select cast(sysdatetimeoffset() at time zone 'Eastern Standard Time' as date)".
What does "grok" mean? Is this a common word. Never heard it before.
to grok is to understand