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

0 vote110 views1 answer
T sql check active deadlock
SQL
0 vote99 views1 answer
Postgresql like
SQL
0 vote108 views1 answer
Oracle table privileges
SQL
0 vote100 views1 answer
Mysql jdbc timezone
SQL
1 vote110 views1 answer
Set autoincrement to 0
SQL
24 votes95 views2 answers
Alter table delete column
SQL
0 vote95 views1 answer
Sql min
SQL
0 vote112 views1 answer
Less than and between in sql query
SQL
4 votes93 views3 answers
Copy table postgres
SQL
1 vote121 views2 answers
This month mysql where
SQL