|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
April 3rd, 2008, 05:49 PM
|
|||
|
|||
|
Change timezone of DB
Hi,
I am a newbie to mssql administration. I would like to change my database time so that when calling getdate() it will return GMT +2 thanks in advance, Eyal. 
|
|
#2
April 4th, 2008, 01:51 PM
|
||||
|
||||
|
See TODATETIMEOFFSET() and related subjects
|
|
#3
April 14th, 2008, 09:04 AM
|
|||
|
|||
thanks for your help,
is there no way to change the behaviour of getdate() to return time in a different time zone. on my server there is a discrepency between the operating system time and the time in the DB (what you get with getdate()) is there a way to resovled this ? if it is of any help my operating system (MS server 2003) shows 18:00 and the DB 10:00 eyal.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Change timezone of DB |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
 |
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
