/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 vote108 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
3 votes123 views1 answer
Oracle cannot access v$session
SQL
1 vote118 views2 answers
Mysql remove first and last character from string
SQL
1 vote112 views2 answers
Extract weekday from date in sql
SQL
0 vote116 views1 answer
Postgres - Login and connect as default user
SQL
0 vote102 views1 answer
Report in database
SQL
11 votes110 views1 answer
Sql query to find duplicates in column
SQL
0 vote111 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote120 views1 answer
Mssql + bit + in python orm
SQL
0 vote111 views1 answer
Mysql récupérer le code création de vue
SQL