NOW, CURDATE, CURTIME in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the MySQL function NOW() return?

NOW() returns the current date and time in the format YYYY-MM-DD HH:MM:SS.

beginner

How is CURDATE() different from NOW() in MySQL?

CURDATE() returns only the current date (YYYY-MM-DD), while NOW() returns both date and time.

beginner

What does the MySQL function CURTIME() return?

CURTIME() returns the current time in the format HH:MM:SS without the date.

beginner

Write a MySQL query to get the current date and time using NOW().

SELECT NOW();

This query returns the current date and time.

beginner

If you want to store only the current time in a column, which function would you use?

You would use CURTIME() to get the current time only.

Which MySQL function returns the current date and time together?

A CURRENT_TIME()

B CURDATE()

C NOW()

D CURTIME()

NOW() returns both current date and time. CURDATE() returns only date, and CURTIME() returns only time.

What format does CURDATE() return?

A YYYY-MM-DD

B HH:MM:SS

C YYYY-MM-DD HH:MM:SS

D MM-DD-YYYY

CURDATE() returns the date in YYYY-MM-DD format.

Which function would you use to get only the current time in MySQL?

A NOW()

B CURTIME()

C CURDATE()

D CURRENT_DATE()

CURTIME() returns only the current time.

What does the query SELECT NOW(); return?

A Current year only

B Current time only

C Current date only

D Current date and time

NOW() returns the current date and time.

If you want to compare only the date part of a datetime column, which function helps you get the current date?

A CURDATE()

B CURTIME()

C NOW()

D TIME()

CURDATE() returns the current date, useful for date-only comparisons.

Explain the difference between NOW(), CURDATE(), and CURTIME() in MySQL.

Think about what part of the date/time each function returns.

Write a simple MySQL query to get the current time and explain what it returns.

Focus on the function that returns time only.