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 vote185 views1 answer
How to check database engine in mysql
SQL
0 vote149 views1 answer
How to select only id where is not in column mysql
SQL
5 votes171 views2 answers
Oracle list columns
SQL
0 vote184 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote160 views4 answers
Mysql replace regex
SQL
0 vote183 views1 answer
Mysql 3 months ago
SQL
0 vote127 views2 answers
Postgresql display subquery as json
SQL
10 votes142 views2 answers
Linux command line import mysql database
SQL
-1 vote189 views1 answer
Create view in mysql workbench
SQL
0 vote201 views5 answers
Right join
SQL