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 |
|
PCJ
Starting Member
2 Posts |
 Posted - 2007-12-11 : 07:41:26
|
Hello Team, Had a doubt,please help me , I have a table which records time as per the GMT, I want to convert it into EST format. Regards,Pratik |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-11 : 07:44:56
|
SELECT DATEADD(HOUR, {Offset value here}, GMT) AS ESTFROM Table1
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-12-11 : 14:21:59
|
| I'm not sure if this helps but if you might be able to make use of GETUTCDATE() to perform your calculations. For example: SELECT DATEDIFF(HOUR, GETDATE(), GETUTCDATE()) |
|
|
|
|
|
|
CONVERTING TIME FROM GMT TO EST