Getting the Universal Time - GMT
Select GetDate() as LocalTime
Select GetUTCDate() as GMT_Time
GetUTCDate Returns the datetime value representing the current UTC time (Coordinated Universal Time or Greenwich Mean Time)
Select DateDiff(second,GetDate(),GetUTCDate() ) as DifferenceinSec
will give you the difference between GMT and your Local Time

Monday, April 16, 2007
Universal Time or Greenwich Meridian Time (GMT)
Labels:
DateDiff,
Difference between GMT and Local,
GetDate,
GetUTCDate,
GMT
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment