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 vote291 views1 answer
Check sql database table lock
SQL
0 vote320 views1 answer
Oracle to_number
SQL
0 vote331 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote307 views1 answer
PSQL use LIKE with timestamps
SQL
1 vote328 views1 answer
Sql insert for each distinct value
SQL
0 vote302 views1 answer
Select nth row in mysql
SQL
0 vote416 views1 answer
Postgresql powershell query
SQL
22 votes326 views3 answers
How to join three tables in sql using joins
SQL
5 votes319 views2 answers
Mysqldump password
SQL
0 vote298 views1 answer
Executescalar in sql server
SQL