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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-24 : 07:52:42
|
| Rami writes "Until recently, I used the function GetDate() in my stored procedures. My server is located in Portland OR, and the time zone setting on the server was PST. Due to some hardware changes, my databases were moved to another database server. This server is set to GMT. Now, all the time stamps I am storing are 7-8 hours after the actual time.I was wandering if there is any function in SQL-Server that can take a time zone as a parameter, and return the current date and time for that time zone. I know SQL-Server has the opposite function GetUCDate(), but I couldn't find one that converts from GMT to other time zone.RegardsRami Cohen" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-11-24 : 13:02:57
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27712 |
 |
|
|
|
|
|
Time Zone Conversion