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 vote307 views1 answer
View to table
SQL
0 vote322 views1 answer
Ubuntu connect to mssql database
SQL
0 vote325 views1 answer
Sql last time database was accessed
SQL
0 vote310 views1 answer
Grepper sql workbench download
SQL
0 vote286 views1 answer
Mysql sleep connections
SQL
0 vote300 views2 answers
Php convert dbf to mysql
SQL
4 votes364 views2 answers
Postgresql float data type
SQL
11 votes338 views3 answers
How to get last row of table in sql
SQL
0 vote347 views1 answer
Postgres list users and roles
SQL
0 vote280 views1 answer
Select mysql limit to 2 decimal places
SQL