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

9 votes102 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote129 views1 answer
Select inside insert query
SQL
0 vote161 views1 answer
MySQL update with subquery
SQL
11 votes118 views2 answers
MySQL DISTINCT
SQL
2 votes107 views1 answer
While loop sql
SQL
1 vote102 views1 answer
Psql show with user is logged in
SQL
0 vote105 views1 answer
Mysql Error Code: 1005
SQL
0 vote107 views1 answer
MySql count occurences more than"
SQL
1 vote103 views1 answer
Oracle select first result
SQL
0 vote107 views1 answer
Postgresql parse json array
SQL