/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

1 vote327 views1 answer
Delete dublicate rows sql
SQL
0 vote550 views1 answer
Power bi connect to postgresql
SQL
0 vote251 views1 answer
Postgres float to int
SQL
7 votes271 views2 answers
Mysql db size
SQL
0 vote230 views1 answer
Oracle sysdba connect as another user
SQL
0 vote266 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote274 views2 answers
Sql query for getting details by id
SQL
0 vote266 views1 answer
How to define a save method in ruby for sql databases
SQL
12 votes276 views1 answer
Psql drop column
SQL
0 vote273 views1 answer
Contact mysql column field
SQL