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 vote200 views1 answer
How get data from database if id not found then search another column
SQL
0 vote202 views2 answers
Update information in a mysql column
SQL
0 vote240 views1 answer
Mysql case when on date
SQL
0 vote189 views1 answer
How to update random rows in sql
SQL
0 vote205 views1 answer
Mysql group by range
SQL
42 votes222 views6 answers
Install beautifulsoup
SQL
1 vote215 views2 answers
Sql server add time to date
SQL
1 vote154 views1 answer
Unique vs distinct sql
SQL
0 vote155 views1 answer
Update sql join multiple tables
SQL
0 vote208 views1 answer
Sqlite to csv statement
SQL