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
Showing posts with label GetUTCDate. Show all posts
Showing posts with label GetUTCDate. Show all posts
Monday, April 16, 2007
Subscribe to:
Posts (Atom)