/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 vote178 views1 answer
Plpgsql raise notice
SQL
0 vote173 views2 answers
Disallowed function mysql to_date()
SQL
0 vote175 views1 answer
Sql select column names starting with
SQL
0 vote168 views1 answer
Database xml sql
SQL
9 votes178 views1 answer
Oracle get table schema
SQL
4 votes210 views2 answers
Postgresql float data type
SQL
92 votes2.3K views6 answers
Substring
SQL
10 votes185 views1 answer
Oracle dependencies table
SQL
7 votes178 views4 answers
Index in mysql
SQL
49 votes277 views6 answers
Mysql add column to table
SQL