Test Your Microsoft SQL Server DATE Functions Knowledge with This Quiz

Progress

True / False

The GETDATE() function returns the current system date and time.

True False

The GETDATE() function retrieves the current system date and time from the server.

True / False

The DATEADD function can add a specified time interval to a date.

True False

The DATEADD function is used to add or subtract a specified time interval from a date.

True / False

The DATEDIFF function returns the number of specified datepart boundaries crossed between two dates.

True False

The DATEDIFF function calculates the difference between two dates in terms of the specified date part, such as year, month, day, etc.

True / False

The GETDATE() function can be used to find the difference between two dates.

True False

The GETDATE() function retrieves the current system date and time, but it does not perform date calculations.

True / False

The SYSDATETIME() function returns the current system date and time with more precision than GETDATE().

True False

The SYSDATETIME() function returns the current system date and time, similar to GETDATE(), but with more precision.

True / False

The DATEPART function can be used to extract parts of a date, such as the year or month.

True False

The DATEPART function extracts the specified part (such as year, month, day, etc.) from a given date.

True / False

The EOMONTH function returns the first day of the month.

True False

The EOMONTH function returns the last day of the month for a given date, not the first day.

True / False

The DATEFROMPARTS function creates a date from individual year, month, and day values.

True False

The DATEFROMPARTS function constructs a date from the provided year, month, and day values.

True / False

The GETUTCDATE() function returns the current date and time in UTC.

True False

The GETUTCDATE() function retrieves the current date and time in Coordinated Universal Time (UTC).

Q10

True / False

The DATENAME function returns the name of the specified datepart of a date.

True False

The DATENAME function returns the name of the specified datepart (such as 'Monday' for day, 'January' for month) from a date.

Q11

True / False

The DATEADD function can subtract days from a given date.

SQL Code

SELECT DATEADD(day, -10, '2024-08-01');
SELECT DATEADD(day, -30, '2024-08-01');
SELECT DATEADD(day, -7, '2024-08-01');
SELECT DATEADD(day, -365, '2024-08-01');
SELECT DATEADD(day, -1, '2024-08-01');

True False

The DATEADD function can add or subtract a specified time interval from a given date. By using a negative value, you can subtract days from the date.

Q12

True / False

The DATEDIFF function can return the number of weeks between two dates.

SQL Code

SELECT DATEDIFF(week, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(week, '2023-01-01', '2024-08-01');
SELECT DATEDIFF(week, '2024-07-01', '2024-08-01');
SELECT DATEDIFF(week, '2024-06-01', '2024-08-01');
SELECT DATEDIFF(week, '2023-01-01', '2023-08-01');

True False

The DATEDIFF function calculates the difference between two dates in terms of the specified date part. In this case, 'week' is used to find the number of weeks between the dates.

Q13

True / False

The FORMAT function can be used to format dates into different styles.

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');
SELECT FORMAT(GETDATE(), 'MMMM dd, yyyy');
SELECT FORMAT(GETDATE(), 'dd/MM/yyyy');
SELECT FORMAT(GETDATE(), 'MM-dd-yyyy');
SELECT FORMAT(GETDATE(), 'yyyyMMdd');

True False

The FORMAT function allows formatting dates and times into various styles and formats, such as 'yyyy-MM-dd', 'MMMM dd, yyyy', etc.

Q14

True / False

The DATEPART function cannot be used to extract the hour part from a date.

SQL Code

SELECT DATEPART(hour, GETDATE());
SELECT DATEPART(hour, '2024-08-01 12:34:56');
SELECT DATEPART(hour, '2024-08-01 23:45:00');
SELECT DATEPART(hour, '2024-08-01 00:00:00');
SELECT DATEPART(hour, '2024-08-01 06:30:00');

True False

The DATEPART function can extract various parts of a date, including the hour, minute, and second. Therefore, it can indeed extract the hour part from a date.

Q15

True / False

The DATENAME function returns the numeric value of the specified date part.

SQL Code

SELECT DATENAME(month, '2024-08-01');
SELECT DATENAME(weekday, '2024-08-01');
SELECT DATENAME(year, '2024-08-01');
SELECT DATENAME(hour, '2024-08-01 12:34:56');
SELECT DATENAME(day, '2024-08-01');

True False

The DATENAME function returns the name of the specified date part (e.g., 'January' for month, 'Monday' for weekday), not the numeric value.

Q16

Single Choice

Which function is used to get the current system date and time?

GETDATE() SYSDATETIME() CURRENT_TIMESTAMPTODAY()

The GETDATE() function retrieves the current system date and time from the server.

Q17

Single Choice

Which function returns the last day of the month for a given date?

EOMONTH() ENDOFMONTH() LASTDAYOFMONTH()MONTHEND()

The EOMONTH function returns the last day of the month for a given date.

Q18

Single Choice

Which function is used to calculate the difference between two dates?

DATEDIFF() DATEADD() DATEDIF()DIFFDATE()

The DATEDIFF function calculates the difference between two dates in terms of the specified date part.

Q19

Single Choice

Which function is used to add a specified time interval to a date?

DATEADD() DATEDIFF() DATEPART()ADDINTERVAL()

The DATEADD function adds or subtracts a specified time interval from a date.

Q20

Single Choice

Which function returns the name of the specified date part of a date?

DATENAME() DATEPART() DATEFROMPARTS()DATENAMEPART()

The DATENAME function returns the name of the specified date part (such as 'Monday' for day, 'January' for month) from a date.

Q21

Single Choice

What does the function GETUTCDATE() return?

SQL Code

SELECT GETUTCDATE();
SELECT CONVERT(VARCHAR, GETUTCDATE(), 120);
SELECT GETUTCDATE() AT TIME ZONE 'UTC';
SELECT CAST(GETUTCDATE() AS DATETIME2);
SELECT DATEADD(hour, 0, GETUTCDATE());

Current UTC date and time Current system date and time Current local date and timeCurrent date without time

The GETUTCDATE() function returns the current date and time in Coordinated Universal Time (UTC).

Q22

Single Choice

Which function extracts the year part of a date?

SQL Code

SELECT YEAR(GETDATE());
SELECT DATEPART(year, GETDATE());
SELECT DATENAME(year, GETDATE());
SELECT EXTRACT(year FROM GETDATE());
SELECT FORMAT(GETDATE(), 'yyyy');

YEAR() DATEPART() DATENAME()EXTRACT()

The YEAR function extracts the year part from a given date.

Q23

Single Choice

Which function creates a date from individual year, month, and day values?

SQL Code

SELECT DATEFROMPARTS(2024, 8, 1);
SELECT DATEFROMPARTS(2020, 2, 29);
SELECT DATEFROMPARTS(2023, 12, 31);
SELECT DATEFROMPARTS(2024, 1, 1);
SELECT DATEFROMPARTS(2024, 7, 15);

DATEFROMPARTS() DATETIMEFROMPARTS() DATEPARTS()PARTSTODATE()

The DATEFROMPARTS function constructs a date from the provided year, month, and day values.

Q24

Single Choice

Which function adds or subtracts a specified time interval from a date?

SQL Code

SELECT DATEADD(day, 10, '2024-08-01');
SELECT DATEADD(month, 6, '2024-08-01');
SELECT DATEADD(year, -1, '2024-08-01');
SELECT DATEADD(hour, 5, GETDATE());
SELECT DATEADD(minute, -30, GETDATE());

DATEADD() DATEDIFF() DATEPART()ADDINTERVAL()

The DATEADD function is used to add or subtract a specified time interval (such as days, months, years) from a given date.

Q25

Single Choice

Which function extracts the month part from a date?

SQL Code

SELECT MONTH(GETDATE());
SELECT DATEPART(month, GETDATE());
SELECT DATENAME(month, GETDATE());
SELECT EXTRACT(month FROM GETDATE());
SELECT FORMAT(GETDATE(), 'MM');

MONTH() DATEPART() DATENAME()EXTRACT()

The MONTH function extracts the month part from a given date.

Q26

Single Choice

Which function formats a date into a specified format?

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');
SELECT FORMAT(GETDATE(), 'MMMM dd, yyyy');
SELECT FORMAT(GETDATE(), 'dd/MM/yyyy');
SELECT FORMAT(GETDATE(), 'MM-dd-yyyy');
SELECT FORMAT(GETDATE(), 'yyyyMMdd');

FORMAT() CONVERT() CAST()STYLE()

The FORMAT function allows formatting dates and times into various styles and formats, such as 'yyyy-MM-dd', 'MMMM dd, yyyy', etc.

Q27

Single Choice

Which function returns the difference between two dates in terms of the specified date part?

SQL Code

SELECT DATEDIFF(day, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(month, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(year, '2020-01-01', '2024-08-01');
SELECT DATEDIFF(hour, '2024-08-01 00:00:00', '2024-08-01 12:34:56');
SELECT DATEDIFF(minute, '2024-08-01 12:00:00', '2024-08-01 12:34:56');

DATEDIFF() DATEADD() DATEPART()DIFFDATE()

The DATEDIFF function calculates the difference between two dates in terms of the specified date part (such as days, months, years, etc.).

Q28

Single Choice

Which function returns the current date and time in the local time zone?

SQL Code

SELECT GETDATE();
SELECT SYSDATETIME();
SELECT CURRENT_TIMESTAMP;
SELECT GETUTCDATE();
SELECT SYSDATETIMEOFFSET();

GETDATE() SYSDATETIME() CURRENT_TIMESTAMPGETUTCDATE()

The GETDATE() function retrieves the current system date and time in the local time zone.

Q29

Single Choice

Which function extracts the day part from a date?

SQL Code

SELECT DAY(GETDATE());
SELECT DATEPART(day, GETDATE());
SELECT DATENAME(day, GETDATE());
SELECT EXTRACT(day FROM GETDATE());
SELECT FORMAT(GETDATE(), 'dd');

DAY() DATEPART() DATENAME()EXTRACT()

The DAY function extracts the day part from a given date.

Q30

Single Choice

Which function returns the name of the specified date part (e.g., 'Monday' for day, 'January' for month)?

SQL Code

SELECT DATENAME(month, '2024-08-01');
SELECT DATENAME(weekday, '2024-08-01');
SELECT DATENAME(year, '2024-08-01');
SELECT DATENAME(hour, '2024-08-01 12:34:56');
SELECT DATENAME(day, '2024-08-01');

DATENAME() DATEPART() DATEFROMPARTS()DATENAMEPART()

The DATENAME function returns the name of the specified date part from a date.

Q31

Multiple Choice

Which functions can be used to get the current date and time in SQL Server? Select all that apply.

SQL Code

SELECT GETDATE();
SELECT SYSDATETIME();
SELECT CURRENT_TIMESTAMP;
SELECT GETUTCDATE();
SELECT SYSDATETIMEOFFSET();

GETDATE() SYSDATETIME() CURRENT_TIMESTAMPGETUTCDATE()

All the listed functions can retrieve the current date and time, but they may have differences in precision and time zone.

Q32

Multiple Choice

Which functions can be used to add or subtract time intervals from a date? Select all that apply.

SQL Code

SELECT DATEADD(day, 10, '2024-08-01');
SELECT DATEADD(month, 6, '2024-08-01');
SELECT DATEADD(year, -1, '2024-08-01');
SELECT DATEADD(hour, 5, GETDATE());
SELECT DATEADD(minute, -30, GETDATE());

DATEADD() DATEDIFF() DATEPART()FORMAT()

The DATEADD function can be used to add or subtract various time intervals (days, months, years, hours, minutes) from a given date.

Q33

Multiple Choice

Which functions can be used to extract parts of a date? Select all that apply.

SQL Code

SELECT DATEPART(year, GETDATE());
SELECT DATEPART(month, GETDATE());
SELECT DATEPART(day, GETDATE());
SELECT DATEPART(hour, GETDATE());
SELECT DATEPART(minute, GETDATE());

DATEPART() DATENAME() YEAR()MONTH()

The DATEPART function can extract various parts of a date (year, month, day, hour, minute, etc.).

Q34

Multiple Choice

Which functions can format dates into different styles? Select all that apply.

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');
SELECT FORMAT(GETDATE(), 'MMMM dd, yyyy');
SELECT FORMAT(GETDATE(), 'dd/MM/yyyy');
SELECT FORMAT(GETDATE(), 'MM-dd-yyyy');
SELECT FORMAT(GETDATE(), 'yyyyMMdd');

FORMAT() CONVERT() CAST()STYLE()

The FORMAT function allows formatting dates and times into various styles and formats.

Q35

Multiple Choice

Which functions can calculate the difference between two dates? Select all that apply.

SQL Code

SELECT DATEDIFF(day, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(month, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(year, '2020-01-01', '2024-08-01');
SELECT DATEDIFF(hour, '2024-08-01 00:00:00', '2024-08-01 12:34:56');
SELECT DATEDIFF(minute, '2024-08-01 12:00:00', '2024-08-01 12:34:56');

DATEDIFF() DATEADD() DATEPART()DATEDIF()

The DATEDIFF function calculates the difference between two dates in terms of the specified date part (days, months, years, hours, minutes, etc.).

Q36

Multiple Choice

Which functions can extract the year part from a date? Select all that apply.

SQL Code

SELECT YEAR(GETDATE());
SELECT DATEPART(year, GETDATE());
SELECT DATENAME(year, GETDATE());
SELECT EXTRACT(year FROM GETDATE());
SELECT FORMAT(GETDATE(), 'yyyy');

YEAR() DATEPART() DATENAME()EXTRACT()

The YEAR function extracts the year part from a given date. DATEPART and DATENAME can also extract the year part.

Q37

Multiple Choice

Which functions can extract the month part from a date? Select all that apply.

SQL Code

SELECT MONTH(GETDATE());
SELECT DATEPART(month, GETDATE());
SELECT DATENAME(month, GETDATE());
SELECT EXTRACT(month FROM GETDATE());
SELECT FORMAT(GETDATE(), 'MM');

MONTH() DATEPART() DATENAME()EXTRACT()

The MONTH function extracts the month part from a given date. DATEPART and DATENAME can also extract the month part.

Q38

Multiple Choice

Which functions can extract the day part from a date? Select all that apply.

SQL Code

SELECT DAY(GETDATE());
SELECT DATEPART(day, GETDATE());
SELECT DATENAME(day, GETDATE());
SELECT EXTRACT(day FROM GETDATE());
SELECT FORMAT(GETDATE(), 'dd');

DAY() DATEPART() DATENAME()EXTRACT()

The DAY function extracts the day part from a given date. DATEPART and DATENAME can also extract the day part.

Q39

Multiple Choice

Which functions can extract the hour part from a date? Select all that apply.

SQL Code

SELECT DATEPART(hour, GETDATE());
SELECT DATEPART(hour, GETDATE());
SELECT DATENAME(hour, GETDATE());
SELECT EXTRACT(hour FROM GETDATE());
SELECT FORMAT(GETDATE(), 'HH');

DATEPART() DATENAME() HOUR()EXTRACT()

The DATEPART and DATENAME functions can extract the hour part from a given date.

Q40

Multiple Choice

Which functions can extract the minute part from a date? Select all that apply.

SQL Code

SELECT DATEPART(minute, GETDATE());
SELECT DATEPART(minute, GETDATE());
SELECT DATENAME(minute, GETDATE());
SELECT EXTRACT(minute FROM GETDATE());
SELECT FORMAT(GETDATE(), 'mm');

DATEPART() DATENAME() MINUTE()EXTRACT()

The DATEPART and DATENAME functions can extract the minute part from a given date.

Q41

Multiple Choice

Which functions can extract the second part from a date? Select all that apply.

SQL Code

SELECT DATEPART(second, GETDATE());
SELECT DATEPART(second, GETDATE());
SELECT DATENAME(second, GETDATE());
SELECT EXTRACT(second FROM GETDATE());
SELECT FORMAT(GETDATE(), 'ss');

DATEPART() DATENAME() SECOND()EXTRACT()

The DATEPART and DATENAME functions can extract the second part from a given date.

Q42

Multiple Choice

Which functions can be used to extract parts of a date? Select all that apply.

SQL Code

SELECT DATEPART(year, GETDATE());
SELECT DATEPART(month, GETDATE());
SELECT DATEPART(day, GETDATE());
SELECT DATEPART(hour, GETDATE());
SELECT DATEPART(minute, GETDATE());

DATEPART() DATENAME() YEAR()MONTH()

The DATEPART function can extract various parts of a date (year, month, day, hour, minute, etc.).

Q43

Multiple Choice

Which functions can format dates into different styles? Select all that apply.

SQL Code

SELECT FORMAT(GETDATE(), 'yyyy-MM-dd');
SELECT FORMAT(GETDATE(), 'MMMM dd, yyyy');
SELECT FORMAT(GETDATE(), 'dd/MM/yyyy');
SELECT FORMAT(GETDATE(), 'MM-dd-yyyy');
SELECT FORMAT(GETDATE(), 'yyyyMMdd');

FORMAT() CONVERT() CAST()STYLE()

The FORMAT function allows formatting dates and times into various styles and formats.

Q44

Multiple Choice

Which functions can calculate the difference between two dates? Select all that apply.

SQL Code

SELECT DATEDIFF(day, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(month, '2024-01-01', '2024-08-01');
SELECT DATEDIFF(year, '2020-01-01', '2024-08-01');
SELECT DATEDIFF(hour, '2024-08-01 00:00:00', '2024-08-01 12:34:56');
SELECT DATEDIFF(minute, '2024-08-01 12:00:00', '2024-08-01 12:34:56');

DATEDIFF() DATEADD() DATEPART()DATEDIF()

The DATEDIFF function calculates the difference between two dates in terms of the specified date part (days, months, years, hours, minutes, etc.).

Q45

Multiple Choice

Which functions can extract the year part from a date? Select all that apply.

SQL Code

SELECT YEAR(GETDATE());
SELECT DATEPART(year, GETDATE());
SELECT DATENAME(year, GETDATE());
SELECT EXTRACT(year FROM GETDATE());
SELECT FORMAT(GETDATE(), 'yyyy');

YEAR() DATEPART() DATENAME()EXTRACT()

The YEAR function extracts the year part from a given date. DATEPART and DATENAME can also extract the year part.

Microsoft SQL Server Database Quiz Questions