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

1 vote207 views2 answers
Sql insert timestamp
SQL
3 votes189 views3 answers
Stop mysql ubuntu
SQL
1 vote192 views1 answer
Best sql course
SQL
0 vote198 views1 answer
Can't connect to postgresql mac os
SQL
1 vote186 views1 answer
Sql sort column by date
SQL
6 votes200 views3 answers
Commit in sql
SQL
0 vote211 views1 answer
Postgresql create query
SQL
3 votes190 views1 answer
Apex set debug level
SQL
0 vote250 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes196 views1 answer
Oracle current date without time
SQL