Date Function: GetDate() and GetUTCDate()

GetDate():
It returns the current system date and time.

Ex:

select getdate() as CurrentDate;

Output:
CurrentDate
2015-10-22 10:49:53.723

GetUTCDate():

It returns the system date and time normalized to UTC.

EX:
select getutcdate() as UTCDate;

OutPut:
UTCDate
2015-10-22 05:19:53.723

See Also:

DatePart()

Share on Google Plus
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment