MySQL Note: Getting the Current Date and Time in MySQL

Create a table:

CREATE TABLE test(
	my_date DATE,
	my_time TIME,
	my_datetime DATETIME
);

Execute the code.

Show the table:

SELECT * FROM test;

Execute the code.

Enter the date, time, and datetime:

INSERT INTO test
VALUES (CURRENT_DATE(), CURRENT_TIME(), NOW());

SELECT * FROM test;

Execute the code.

If you want to enter date for tomorrow:

INSERT INTO test
VALUES (CURRENT_DATE() + 1, NULL, NULL);

SELECT * FROM test;

Execute the code.

If you want to enter date for yesterday:

INSERT INTO test
VALUES (CURRENT_DATE() - 1, NULL, NULL);

SELECT * FROM test;

Execute the code.