/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 vote153 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote145 views1 answer
Openquery insert into linked server
SQL
0 vote155 views1 answer
PSQL qith variables
SQL
1 vote170 views2 answers
Mysql extract number from string
SQL
0 vote184 views1 answer
Sp help text in postgresql
SQL
3 votes148 views2 answers
Sql asc
SQL
0 vote158 views1 answer
Oracle list partitions
SQL
3 votes178 views3 answers
Mysql auto increment after delete
SQL
9 votes142 views2 answers
Cmd to rename a collumn name in sql
SQL
14 votes158 views3 answers
Trim sql
SQL