/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 vote173 views1 answer
Sqlite closes value
SQL
0 vote141 views1 answer
Mysql collation for all languages
SQL
0 vote188 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote204 views1 answer
Consecutive numbers sql
SQL
5 votes190 views2 answers
Ranking functions in sql
SQL
0 vote186 views1 answer
Get the First and Last Word from a String or Sentence
SQL
11 votes266 views1 answer
Oracle insert from select
SQL
0 vote164 views1 answer
Create date sql
SQL
24 votes174 views4 answers
How to add column sql
SQL
11 votes196 views5 answers
Sql server reset identity
SQL