Showing posts with label GetUTCDate. Show all posts
Showing posts with label GetUTCDate. Show all posts
StumbleUpon
Share on Facebook

Monday, April 16, 2007

Universal Time or Greenwich Meridian Time (GMT)

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
Related Posts Plugin for WordPress, Blogger...