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

2 votes174 views1 answer
Datefromparts mssql
SQL
0 vote153 views2 answers
Get item by composite primary key mysql
SQL
1 vote143 views1 answer
STOP message of how many rows affected sql
SQL
0 vote143 views1 answer
Implicit inner join table alias with id values
SQL
0 vote152 views1 answer
Select multiple row from primary key sql
SQL
0 vote143 views1 answer
Convert .mdf to .bak
SQL
1 vote141 views1 answer
Postgres concat_ws
SQL
0 vote144 views1 answer
Postgresql not in alternative
SQL
0 vote139 views1 answer
Inserted row count tsql
SQL
1 vote127 views3 answers
How to filter repeated same result using sql query
SQL