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

4 votes132 views1 answer
Mac install mysql
SQL
2 votes122 views1 answer
Plsql block
SQL
1 vote111 views1 answer
Mysql see column types
SQL
3 votes161 views2 answers
Oracle drop column
SQL
1 vote92 views2 answers
Last working day in week date function in sql
SQL
0 vote122 views1 answer
C# mysql data reader from two tables
SQL
2 votes128 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote170 views2 answers
Sql split string by space
SQL
1 vote176 views1 answer
Mysql is odd
SQL
0 vote236 views1 answer
Sqlite woth cmake
SQL