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

6 votes190 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote140 views1 answer
Isnull sql server
SQL
0 vote168 views2 answers
Check if sql temp table exists
SQL
0 vote133 views1 answer
Data directory postgresql
SQL
0 vote136 views1 answer
How to select all fieldsin a soql query
SQL
0 vote140 views1 answer
Oracle exchange partition
SQL
12 votes141 views2 answers
Delete all entries postgres
SQL
0 vote139 views1 answer
Get record which is available in one table but not in another mysql
SQL
1 vote187 views4 answers
Alter schema sql
SQL
0 vote172 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL