Time zones? - SQL Server Forums

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

Site Related Forums

Site Related Discussions

Time zones?

Author

Topic

mark1504
Posting Yak Master

103 Posts

Posted - 2004-03-09 : 06:30:08

Living in good ol' GMT I get very disturbed to find out I've made postings before 11am! Well, that's what the forum says. Is there a way to offset the timezone on the forum, or do I have to change my computer's clock to Eastern time????

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2004-03-09 : 06:53:59

That is an excellent feature phpBB has. I don't think the standard Snitz forum software installation can handle this on a per-user basis.
What about using some T-SQL


DECLARE @delta INT

EXEC master.dbo.xp_regread 
	'HKEY_LOCAL_MACHINE'
	, 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation'
	, 'ActiveTimeBias'
	, @delta OUT
SELECT 
	GETDATE() AS Aktuelle_Zeit
	, DATEADD( Minute, @delta,GETDATE()) AS Greenwich_Mean_Time
	, @delta as Delta
Aktuelle_Zeit                                          Greenwich_Mean_Time                                    Delta       
------------------------------------------------------ ------------------------------------------------------ ----------- 
2004-03-09 12:51:10.483                                2004-03-09 11:51:10.483                                -60

(1 row(s) affected)

--Frank
http://www.insidesql.de

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources