Mysql datetime

Php mysql datetime

date("Y-m-d H:i:s")

Mysql datetime

-- MySQL DATE Format: 'YYYY-MM-DD'
-- MySQL DATETIME Format: 'YYYY-MM-DD hh:mm:ss'

Source: dev.mysql.com

Mysql current date

SELECT NOW();
It returns current date and time.

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 vote160 views1 answer
Delete mysql ubuntu 20.04
SQL
2 votes128 views1 answer
How to insert string variable into sqlite database
SQL
2 votes119 views1 answer
Oracle insert or update
SQL
10 votes127 views4 answers
How to alter table name in mysql
SQL
28 votes123 views6 answers
Sql update
SQL
0 vote115 views1 answer
Postgre admin slow
SQL
1 vote130 views5 answers
Postgresql difference between two dates in days
SQL
0 vote120 views1 answer
Sql get year from datetime field
SQL
0 vote126 views1 answer
How to start my sql server on mac
SQL
0 vote108 views1 answer
Sql select duplicates based on two columns
SQL