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 |
|
jamie_pattison
Yak Posting Veteran
65 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-11 : 08:32:19
|
| You want in GMT? then use GETUTCDATE() instead of GETDATE() |
 |
|
|
jamie_pattison
Yak Posting Veteran
65 Posts |
Posted - 2008-08-11 : 08:39:29
|
| Its already using GETUTCDATE except for one of them. I made the change but it made no difference....... |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-11 : 08:52:49
|
| Do you have tried to replace all GETUTCDATE() with GETDATE()?WebfredToo Old to Rock 'n' Roll, Too Young to Die |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-11 : 09:52:09
|
quote:
Originally posted by jamie_pattison
Its already using GETUTCDATE except for one of them. I made the change but it made no difference.......
what's your actual time zone? |
|
|
|
jamie_pattison
Yak Posting Veteran
65 Posts |
Posted - 2008-08-11 : 10:43:42
|
| GMT Standard Time |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-11 : 11:49:41
|
quote:
Originally posted by jamie_pattison
GMT Standard Time
and what does GETDATE() & GETUTCDATE() return for you? |
|
|
|
|
|
|
UTC Time in expression