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

3 votes358 views1 answer
Oracle transaction commit rollback example
SQL
0 vote369 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote366 views1 answer
View psql output in horizontal scrolling
SQL
0 vote324 views1 answer
Mysql Error Code: 1005
SQL
0 vote345 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
12 votes347 views4 answers
How to take database dump in postgresql
SQL
0 vote359 views1 answer
Sql declare variable single line
SQL
0 vote371 views1 answer
Select year from dual oracle
SQL
2 votes363 views1 answer
Coalesce sql
SQL
2 votes333 views1 answer
Oracle sql concatenate results into string
SQL