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 vote219 views1 answer
If null don't update
SQL
1 vote238 views1 answer
Sql dcl
SQL
0 vote251 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote245 views1 answer
Postgresql replace html tags from string
SQL
0 vote240 views1 answer
Mysql change innodb to myisam
SQL
1 vote227 views2 answers
Change table name phpmyadmin
SQL
0 vote250 views1 answer
Oracle session statistics
SQL
13 votes236 views1 answer
Views in sql
SQL
2 votes233 views1 answer
Sql server: select column values as comma separated string
SQL
15 votes348 views2 answers
Sql order by alphabetical
SQL