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 vote263 views1 answer
For row in sql database python loop
SQL
0 vote244 views1 answer
Drop CHECK constraint sql
SQL
7 votes264 views2 answers
Phpmyadmin change password
SQL
0 vote229 views1 answer
Cannot start database server xampp mac os
SQL
12 votes244 views4 answers
Mysql get date difference in hours
SQL
0 vote234 views3 answers
Sql count condition
SQL
1 vote231 views3 answers
Postgresql crete view
SQL
1 vote229 views1 answer
How to truncate a table in databse
SQL
0 vote236 views1 answer
Postgres drop type
SQL
1 vote231 views2 answers
Replace text in sql
SQL