MySQL: CURRENT_DATE() & CURRENT_TIME()

#MySQL #SQL #course

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

INSERT INTO test
VALUES(CURRENT_DATE(), CURRENT_TIME(), NOW());
SELECT * FROM test;

[BroCodez]

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

INSERT INTO test
VALUES(CURRENT_DATE(), CURRENT_TIME(), NOW());
SELECT * FROM test;

[UttejBobby]

INSERT INTO test
VALUES(CONVERT (DATE, GETDATE()), CONVERT (TIME, GETDATE()), GETDATE());
SELECT * FROM test

[abdulbasit]

Woo hoo let's go to another video ❤

[wandstick]

Been waiting for this since Java tutorial was released!

[hassaanhameed]

precise by the way I'm revisising the sql

[tanghongsheng]

similar as using getdate(), but overall good video bro.

[visheshmukherjee]

When I used the query :

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


On 2021-01-01, It gave me the error:

ERROR 1292 (22007): Incorrect date value: '20221200' for column 'my_date' at row 1

Because 2022-12-00 is not valid. So that's something to look out for.