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 vote247 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
4 votes269 views1 answer
Postgresql create table with index
SQL
0 vote264 views2 answers
Get all index postgres
SQL
0 vote285 views1 answer
Sql order by except one row
SQL
0 vote470 views1 answer
Get first match in each group mysql query
SQL
0 vote262 views1 answer
How to avoid duplicate records in sqlite
SQL
5 votes292 views2 answers
Mysqldump password
SQL
0 vote261 views1 answer
2020 new year
SQL
0 vote273 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote316 views2 answers
Drop table with constraints
SQL