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 vote270 views1 answer
Access refused mysql xampp server
SQL
0 vote280 views1 answer
Regex mongoose
SQL
24 votes269 views5 answers
Sql reset auto increment
SQL
0 vote308 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote296 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote285 views1 answer
Sql developer sql worksheet not showing
SQL
3 votes281 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
-1 vote275 views1 answer
Export mysql table to file
SQL
7 votes308 views1 answer
Query postgres delete duplicates
SQL
3 votes289 views2 answers
Find the median in sql
SQL