Sql Server DateTime - Timezone

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 2005 Forums

Transact-SQL (2005)

Sql Server DateTime - Timezone

Author

Topic

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-06-11 : 12:41:39

Is there any in-built function in SQL Server 2005, which will convert a given date time to a specified timezone? or to UTC?.

Getutcdate() just returns UTC date for the current date time. I did notice few topics in the forum on this. I'm just wondering if something has changed in Sql Server 2005.

Thanks

Thanks
Karunakaran

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-11 : 14:35:44

nope.

you can use datediff in hours between the getdate and getutcdate
but that's about it from the sql server's point of view.

maybe this will help you:
http://weblogs.sqlteam.com/mladenp/archive/2006/05/21/9926.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-06-11 : 14:51:56

Thanks.

Looks like Oracle has this kind of options, how did SQL Server missed it :(

Thanks
Karunakaran

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-11 : 14:59:12

Search the forums for my timezone conversion function. It's name is udf_Timezone_Conversion. We have made updates to it for the new DST changes, but the old version should at least give you a start.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-06-11 : 15:04:55

quote:
Originally posted by tkizer

Search the forums for my timezone conversion function. It's name is udf_Timezone_Conversion. We have made updates to it for the new DST changes, but the old version should at least give you a start.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Yeah, I did saw that function earlier when I was searching.
I was just wondering if something had changed in SQL Server 2005, which I might have missed.

Thanks
Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources