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 |
|
dbayona
Starting Member
4 Posts |
 Posted - 2007-07-14 : 13:47:04
|
| Hi:I have in table with the local date and time (colombia) of all the inserted records, but I need to do a select where I returned these records but that turns me the date and the local time in Date and Hour UTC (GMT) and show them in the select; have I no idea of as I can do it? I hope that someone support me. Thanx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 20:08:04
|
| You need convert it with dateadd function. By the way, you can get utc date time with getutcdate() function. |
 |
|
|
dbayona
Starting Member
4 Posts |
Posted - 2007-07-15 : 12:08:44
|
| ok thanx for your support...this was very useful |
|
|
|
|
|
|
Local Date and Time to UTC?