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 vote194 views1 answer
Sql values not in another table
SQL
1 vote174 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote172 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote228 views1 answer
Postgres get running query
SQL
0 vote168 views1 answer
Add sqlite3 in lumen
SQL
0 vote170 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
17 votes194 views3 answers
Postgresql list users
SQL
0 vote185 views2 answers
Sql server select first day of previous year
SQL
2 votes215 views1 answer
Mysql shell insert into
SQL
9 votes164 views2 answers
Mysql change value
SQL