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 |
|
JohnBonam
Starting Member
3 Posts |
 Posted - 2008-05-08 : 13:03:49
|
| Guys,Need ur help on this...how can I change the datetime stamp to GMT in a table, it's a SQL Server 2005 database.The timestamps are EST,PST,CT...so have to change the arrival and departure times to GMT time zoneThanks,JohnB |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-08 : 13:05:45
|
| Use GETUTCDATE()http://msdn.microsoft.com/en-us/library/ms178635.aspx |
 |
|
|
JohnBonam
Starting Member
3 Posts |
Posted - 2008-05-08 : 13:08:07
|
| Hi Visakh,I'm new to SQL Server...could you please elaborate on how to use GETUTCDATE()Thanks,John |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-08 : 13:29:48
|
| INSERT INTO YourTable (DateColumn)SELECT GETUTCDATE()will populate the column with current GMT time |
|
|
|
JohnBonam
Starting Member
3 Posts |
Posted - 2008-05-08 : 18:56:13
|
| Thanks Visakh |
|
|
|
|
|
|
Convert time to GMT