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 vote308 views1 answer
Sql sort ages
SQL
0 vote288 views1 answer
ORA-00942
SQL
0 vote261 views1 answer
T-sql conditional order by multiple columns
SQL
-1 vote264 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote294 views1 answer
Sql alter column name sql server
SQL
4 votes311 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote283 views1 answer
Connecting mySQL to STS
SQL
5 votes286 views1 answer
Commentaire table oracle
SQL
0 vote301 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote301 views1 answer
Mysql db dump restore max file size issue
SQL