8:21 AM
Deep Dey
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
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
0 comments:
Post a Comment