NOW, CURDATE, CURTIME in MySQL - Step-by-Step Execution

Concept Flow - NOW, CURDATE, CURTIME

Call NOW()

→Return current date and time

↓

Call CURDATE()

→Return current date only

↓

Call CURTIME()

→Return current time only

↓

Use results in query or display

Each function fetches the current date/time from the system: NOW() gives date and time, CURDATE() gives only date, CURTIME() gives only time.

Execution Sample

MySQL

SELECT NOW() AS current_datetime,
       CURDATE() AS current_date,
       CURTIME() AS current_time;

This query returns the current date and time, current date only, and current time only.

Execution Table

Step	Function Called	Returned Value	Explanation
1	NOW()	2024-06-15 14:23:45	Returns full current date and time
2	CURDATE()	2024-06-15	Returns only the current date
3	CURTIME()	14:23:45	Returns only the current time
4	Query Result	{"current_datetime":"2024-06-15 14:23:45","current_date":"2024-06-15","current_time":"14:23:45"}	Final output row with all three values

💡 All functions return current system date/time values at query execution time

Variable Tracker

Variable	Start	After NOW()	After CURDATE()	After CURTIME()	Final
current_datetime	NULL	2024-06-15 14:23:45	2024-06-15 14:23:45	2024-06-15 14:23:45	2024-06-15 14:23:45
current_date	NULL	NULL	2024-06-15	2024-06-15	2024-06-15
current_time	NULL	NULL	NULL	14:23:45	14:23:45

Key Moments - 3 Insights

Why does NOW() return both date and time, but CURDATE() only returns the date?

NOW() returns the full timestamp including date and time as shown in execution_table row 1, while CURDATE() extracts only the date part as shown in row 2.

If I run the query at different times, will the results change?

Yes, because these functions fetch the current system date/time at the moment of query execution, so values update each time you run the query (see exit_note).

Can CURTIME() return a date value?

No, CURTIME() returns only the time portion as shown in execution_table row 3, it never returns a date.

Visual Quiz - 3 Questions

Look at the execution table, what does CURDATE() return at step 2?

A Current time only

B Current date only

C Current date and time

D NULL

💡 Hint

Check execution_table row 2 under Returned Value

At which step does the function return only the time portion?

A Step 3

B Step 2

C Step 1

D Step 4

💡 Hint

Look at execution_table row 3 for CURTIME() output

If you want both date and time in your query result, which function should you use?

A CURDATE()

B CURTIME()

C NOW()

D None of these

💡 Hint

Refer to execution_table row 1 for NOW() output

Concept Snapshot

NOW() returns current date and time.
CURDATE() returns current date only.
CURTIME() returns current time only.
All fetch system time at query execution.
Use them to get current timestamps in queries.

Full Transcript

This lesson shows how MySQL functions NOW(), CURDATE(), and CURTIME() work. NOW() returns the full current date and time, CURDATE() returns only the date, and CURTIME() returns only the time. Each function gets the current system date/time when the query runs. The example query selects all three values. The execution table shows each function call and its returned value. Variables track how each value is assigned step-by-step. Key moments clarify common confusions like why NOW() returns both date and time but CURDATE() does not. The quiz tests understanding by asking about specific steps and outputs. This helps beginners see exactly what each function returns and when.