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 vote285 views1 answer
Calculate age in sql
SQL
12 votes282 views5 answers
Rename table in mysql
SQL
0 vote222 views1 answer
Sql new line output
SQL
4 votes253 views1 answer
Check database name postgresql
SQL
0 vote271 views1 answer
Sql server user permissions and roles
SQL
0 vote257 views1 answer
Oracle synonym procedure dblink
SQL
0 vote246 views1 answer
Sql examples from your work
SQL
0 vote298 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote270 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote246 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL