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 vote156 views1 answer
Pl sql insert into table
SQL
11 votes153 views2 answers
Mysql set safe mode off
SQL
0 vote184 views1 answer
Day of the week sqlite
SQL
0 vote145 views1 answer
Postrgres trunc
SQL
4 votes160 views2 answers
Oracle default date format
SQL
0 vote208 views1 answer
Updating database in sql
SQL
4 votes180 views2 answers
Oracle unlock account
SQL
25 votes178 views6 answers
How to change column name in mysql
SQL
0 vote151 views1 answer
Can we rollback deleted data in sql
SQL
0 vote220 views1 answer
Opensuse start MySQL
SQL