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 |
|
netjam
Starting Member
37 Posts |
 Posted - 2008-05-27 : 20:30:51
|
| One server handles to systems, which serves two different regionwith different timezones. One for Canada other for UK. I need to handle both.Server located in UK.Cteating a function wich correct time offset is one idea. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-28 : 03:11:27
|
GETUTCDATE() instead of GETDATE() perhaps?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
netjam
Starting Member
37 Posts |
Posted - 2008-05-28 : 03:43:18
|
| I don't understand how this would help. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-28 : 04:48:03
|
quote:
Returns the datetime value representing the current UTC time (Coordinated Universal Time or Greenwich Mean Time). The current UTC time is derived from the current local time and the time zone setting in the operating system of the computer on which the instance of Microsoft SQL Server is running.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Recording Dates Time