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

3 votes126 views1 answer
MySQL DELETE JOIN
SQL
0 vote145 views1 answer
Php delete database
SQL
0 vote152 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote167 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote132 views1 answer
Update having mysql
SQL
0 vote162 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote137 views1 answer
Mysql function variable
SQL
2 votes148 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
13 votes135 views2 answers
Check if value is null mysql
SQL
0 vote144 views1 answer
Oracle service name view
SQL