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

2 votes182 views1 answer
Pdo mysql insert
SQL
1 vote177 views3 answers
Mysql Server Start
SQL
1 vote160 views1 answer
Oracle lock user
SQL
0 vote217 views1 answer
Postgres docs /copy metacomand
SQL
0 vote177 views1 answer
Android sqlite get rows count
SQL
1 vote180 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote173 views4 answers
First max salary in sql
SQL
0 vote209 views1 answer
Flask sqlalchemy session delete
SQL
2 votes227 views3 answers
Sql server reseed identity column
SQL
2 votes169 views1 answer
Mysql sysdate
SQL