/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 vote125 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote125 views1 answer
Allow external access to mysql
SQL
6 votes131 views2 answers
How to get yesterday date in mysql
SQL
6 votes123 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
8 votes109 views2 answers
Phpmyadmin password
SQL
1 vote124 views1 answer
Sql not equal multiple columns
SQL
1 vote130 views2 answers
Sql server concat string and int
SQL
1 vote189 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
4 votes116 views3 answers
Oracle sql first day of quarter
SQL
0 vote129 views1 answer
Mysql subtract month from timestamp
SQL