/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 vote305 views1 answer
Create domain sql
SQL
1 vote320 views3 answers
Postgresql crete view
SQL
0 vote357 views2 answers
List all constraints in postgres
SQL
1 vote320 views1 answer
Import sql file mysql commadn line
SQL
0 vote348 views1 answer
Mysql 3 months ago
SQL
1 vote332 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote351 views1 answer
Hour and minute between two datatime sql
SQL
0 vote340 views1 answer
Provide hardcoded value in the mysql query
SQL
5 votes336 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote352 views1 answer
Order child below the parent in mysqli
SQL