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 vote160 views1 answer
Insert or update sql firebird
SQL
0 vote136 views1 answer
Postgresql create user roles
SQL
19 votes172 views6 answers
Create table sqlite
SQL
3 votes146 views3 answers
Remove all spaces from string sql
SQL
0 vote160 views1 answer
Postgresql custom order by
SQL
40 votes213 views6 answers
Update table mysql
SQL
0 vote153 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote153 views1 answer
Less than and between in sql query
SQL
10 votes156 views1 answer
Oracle dependencies table
SQL
1 vote159 views2 answers
Rebuild index sql server
SQL