mysql datetime

1date("Y-m-d H:i:s")

1SELECT NOW();
2It returns current date and time.

1-- MySQL DATE Format: 'YYYY-MM-DD'
2-- MySQL DATETIME Format: 'YYYY-MM-DD hh:mm:ss'

1DATE : YYYY-MM-DD format
2DATETIME : YYYY-MM-DD HH:MM:SS format
3TIMESTAMP : X s from 1970 format
4TIME : HH:MM:SS format

1INSERT INTO ... VALUES ('YYYY-MM-DD HH:MM:SS');

1
2        
3            
4        
5     CREATE TABLE people (
6    id INT AUTO_INCREMENT PRIMARY KEY,
7    first_name VARCHAR(50) NOT NULL,
8    last_name VARCHAR(50) NOT NULL,
9    birth_date DATE NOT NULL
10);