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 vote142 views1 answer
Oracle step procedure
SQL
0 vote152 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote135 views1 answer
Mysql trigger to delete old data
SQL
0 vote119 views1 answer
How to use sqlcommand
SQL
0 vote111 views2 answers
Sql last updated
SQL
0 vote129 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote115 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote115 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote116 views1 answer
Turnicate in mysql
SQL
8 votes123 views2 answers
Oracle undo usage
SQL