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 vote353 views2 answers
Sql example query
SQL
1 vote405 views4 answers
How to check table in postgresql from terminal
SQL
0 vote344 views1 answer
Safe mysql
SQL
0 vote371 views1 answer
Mysql disable triggers
SQL
1 vote389 views2 answers
Sql insert timestamp
SQL
0 vote341 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
3 votes358 views2 answers
Plsql print
SQL
10 votes347 views2 answers
Sql merge statement
SQL
0 vote298 views1 answer
Oracle sql developer script output limit
SQL
0 vote372 views1 answer
Convert multiple columns to ROws in sql server
SQL