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 vote424 views1 answer
Finding leap year in sql
SQL
0 vote303 views1 answer
Mysql select top 2
SQL
8 votes331 views2 answers
Phpmyadmin password
SQL
1 vote368 views3 answers
Execute sp in sql server
SQL
1 vote358 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
19 votes387 views6 answers
Mysql if null
SQL
0 vote338 views1 answer
What does the -p flag do in mysql cli
SQL
-1 vote308 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote369 views1 answer
Database traccar
SQL
1 vote374 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL