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 vote353 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
33 votes388 views6 answers
Sql delete
SQL
1 vote326 views3 answers
Get all tables postgres
SQL
0 vote326 views1 answer
Android sqlite add column if not exists
SQL
1 vote310 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote367 views1 answer
CONVERT time string into 12 hours in sql
SQL
1 vote336 views2 answers
Get table column names sql laravel
SQL
0 vote341 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote320 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote346 views1 answer
Postgresql extract hour and minutes from timestamp
SQL