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 vote197 views1 answer
Compare subqueries oracle
SQL
7 votes294 views2 answers
Oracle foreign key reference table
SQL
0 vote199 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote210 views2 answers
Plsql function that return a table
SQL
1 vote214 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote219 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote330 views2 answers
Mysql insert rows to another database
SQL
0 vote265 views3 answers
Classement rang mysql 7
SQL
0 vote293 views1 answer
Install ms sql server management studio
SQL
0 vote216 views1 answer
Default password for mysql_secure_installation in mac
SQL