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

0 vote221 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
5 votes211 views2 answers
Mysql drop table cascade
SQL
5 votes214 views3 answers
String concatenation sql server
SQL
1 vote222 views1 answer
Show structure of table in sql
SQL
0 vote213 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote227 views1 answer
Compare two tables to find unmatched records
SQL
0 vote218 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote212 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote220 views1 answer
Mysql locate
SQL
0 vote207 views1 answer
Take sql dump in to file
SQL