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 vote182 views1 answer
Will graphql replace sql
SQL
0 vote219 views1 answer
Postgres list all triggers
SQL
2 votes177 views1 answer
Mysql sysdate - 1 day
SQL
0 vote195 views1 answer
Count in sql and diff
SQL
0 vote192 views1 answer
Mysql récupérer le code création de vue
SQL
12 votes215 views4 answers
How to drop all tables in postgresql
SQL
0 vote180 views1 answer
Mysql url data type
SQL
0 vote204 views1 answer
Add new column in sql with foreign key
SQL
0 vote180 views1 answer
Mysql could not fetch tables
SQL
0 vote260 views1 answer
Sql insert exemplo
SQL