/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 vote193 views1 answer
Show mysql account privilleges
SQL
-1 vote142 views1 answer
Partial search in sql
SQL
0 vote133 views1 answer
Convert rows to columns in sql server
SQL
0 vote135 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote142 views1 answer
Version and edition of SQL Server Database Engine
SQL
2 votes142 views1 answer
Datetrunc
SQL
0 vote141 views1 answer
How to add boolean column in postgresql
SQL
1 vote169 views1 answer
Drop colum oracle 18c
SQL
4 votes152 views1 answer
Sql quote in string
SQL
0 vote142 views1 answer
Oracle table privileges
SQL