/SQL/How to assign date field for table in mysql

How to assign date field for table in mysql

Mysql format date

DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats

Source: mysqltutorial.org

How to assign date field for table in mysql

        
            
        
     CREATE TABLE people (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    birth_date DATE NOT NULL
);

Source: mysqltutorial.org

Similar codes

0 vote312 views1 answer
Mysqli or pdo
SQL
12 votes386 views2 answers
Select into insert sql server
SQL
0 vote379 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
9 votes342 views4 answers
How to remove duplicate in sql
SQL
0 vote356 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote348 views1 answer
Select top 3 sql
SQL
1 vote362 views1 answer
DATE_SUB postgres
SQL
10 votes356 views1 answer
Oracle all_dependencies
SQL
1 vote348 views1 answer
Oracle apex prevent initial load
SQL
36 votes422 views6 answers
Change column data type sql
SQL