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 votes264 views1 answer
Oracle kill session by sql_id
SQL
1 vote222 views1 answer
Foreign key in oracle sql developer
SQL
0 vote235 views1 answer
Clone table structure mysql
SQL
0 vote257 views1 answer
Utiliser sql ligne de commande
SQL
0 vote258 views3 answers
Sql count condition
SQL
0 vote274 views1 answer
Postgres regex word boundary
SQL
0 vote259 views1 answer
Mysql repair a table
SQL
2 votes230 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
5 votes303 views1 answer
Mysql count lines
SQL
0 vote261 views1 answer
Mariadb select limit offset
SQL