Get current DATE or DATETIME

Example 1

Use the following to get current DATE:

SELECT CONVERT(date, getdate());

Use the following to get current DATETIME:

SELECT getdate();

Use the following to get current DATETIME in UTC:

SELECT GETUTCDATE();

You can find an interactive version of this example following this link .