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 votes345 views2 answers
Oracle last day of month
SQL
14 votes401 views4 answers
Sql compiler
SQL
0 vote372 views1 answer
Alter table change default
SQL
-1 vote345 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote364 views1 answer
Show the colums of table sql
SQL
0 vote335 views1 answer
Cara menampilkan user di mysql terminal
SQL
9 votes330 views4 answers
Add primary key to existing table sql
SQL
6 votes336 views2 answers
Mysql first day of month
SQL
0 vote338 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote350 views1 answer
Find duplicate users by email address in mysql
SQL