/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 vote100 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote161 views1 answer
Sql to search who modified
SQL
0 vote92 views1 answer
How to get employee having maximum experience in mysql
SQL
6 votes108 views1 answer
Oracle pl sql source
SQL
1 vote115 views1 answer
Psql connect to another database
SQL
8 votes115 views1 answer
Oracle search stored procedures for text
SQL
1 vote132 views1 answer
Drop colum oracle 18c
SQL
0 vote103 views1 answer
Select all columns except one sql
SQL
0 vote159 views3 answers
Osx stop mysql service
SQL
0 vote115 views2 answers
Advantages of stored procedures sql
SQL