Answers for "mysql datetime"

SQL
8

php mysql datetime

date("Y-m-d H:i:s")
Posted by: Guest on July-05-2019
4

mysql current date

SELECT NOW();
It returns current date and time.
Posted by: Guest on April-14-2020
4

mysql datetime

-- MySQL DATE Format: 'YYYY-MM-DD'
-- MySQL DATETIME Format: 'YYYY-MM-DD hh:mm:ss'
Posted by: Guest on June-07-2021
1

date vs datetime

DATE : YYYY-MM-DD format
DATETIME : YYYY-MM-DD HH:MM:SS format
TIMESTAMP : X s from 1970 format
TIME : HH:MM:SS format
Posted by: Guest on October-30-2020
0

mysql timestamp format

INSERT INTO ... VALUES ('YYYY-MM-DD HH:MM:SS');
Posted by: Guest on October-29-2020
0

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
);
Posted by: Guest on June-18-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language