/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 vote156 views1 answer
Automate mysql cli query
SQL
14 votes218 views5 answers
Set password for postgres user ubuntu
SQL
0 vote172 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote172 views1 answer
Supprimer les valeur d'une table mysql
SQL
17 votes143 views6 answers
What is cursor in sql server with example
SQL
0 vote164 views1 answer
Alter precision
SQL
0 vote179 views1 answer
Oracle sql all days except weekends
SQL
0 vote186 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote166 views1 answer
Mysql 1 hour ago
SQL
0 vote177 views4 answers
How to get max salary in each department in sql
SQL