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

4 votes139 views3 answers
Mysql modify foreign key
SQL
50 votes229 views6 answers
Sql count duplicate rows
SQL
3 votes136 views5 answers
No module named 'MySQLdb'
SQL
0 vote146 views2 answers
What is rownum in oracle
SQL
3 votes139 views1 answer
Unsigned int in mysql
SQL
0 vote133 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote158 views1 answer
Sql server if exists update else insert
SQL
2 votes148 views1 answer
Sql get the name of user pc
SQL
22 votes194 views4 answers
Mysql date format
SQL
0 vote149 views1 answer
Selecting Multiple Columns in SQL
SQL