Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Accessing time zone setting

Author  Topic 

izaltsman
A custom title

1139 Posts

Posted - 2001-04-06 : 11:00:54
Does anyone know how I can access the NT server's time zone setting, or better yet, the Greenwitch Mean Time adjustment factor for that time zone?
So my resultset on the server operating on Eastern Standard Time would contain dates in this format:

2001-04-06 10:15:22GMT-05:00

Thank you!

   

- Advertisement -