MySQL: CURRENT_DATE() & CURRENT_TIME()

6 Views
Published
#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;
Category
Bro Code
Tags
MySQL course, SQL course, MySQL tutorial
Be the first to comment