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

3 votes172 views1 answer
Laravel database Using Named Bindings
SQL
0 vote176 views1 answer
Raiserror with nowait
SQL
1 vote166 views1 answer
Set autoincrement to 0
SQL
16 votes223 views6 answers
Python sqlite
SQL
1 vote130 views1 answer
Import in mysql without a software
SQL
0 vote179 views1 answer
Sql put two columns into one
SQL
0 vote154 views1 answer
Mysql update sequence with order by
SQL
11 votes175 views2 answers
Safe mode off mysql
SQL
3 votes171 views2 answers
Check data in table mysql
SQL
0 vote190 views1 answer
Replace sqlalchemy
SQL