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 - 2005-05-30 : 08:47:19
|
| Vivek writes "Hi,I am facing a problem to tackle timezones and daylight savingson the Server side.The Reports which I am generating requires the information given to the user about timezones(also considering daylight saving).I made a SP which gives me timezones but it does not take into account the daylight saving.Is there a way out in SQL Server by which I can Identify the same.Thanks Vivek" |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-05-31 : 01:30:47
|
| There is the GETUTCDATE() function to get Greenwich time which I doubt is what you are looking for. The actual timezone and DST seting you would need to get from Windows; not from SQL.HTH=================================================================The surest way to corrupt a youth is to instruct him to hold in higher esteem those who think alike than those who think differently. -Friedrich Nietzsche, philosopher (1844-1900) |
 |
|
|
vivek.kumargupta
Starting Member
45 Posts |
Posted - 2005-06-01 : 00:29:00
|
| Ok ,Thanks |
|
|
|
|
|
|
Time zone and daylight saving problem