Breaking News: Grepper is joining You.com. Read the official announcement!

sql date/time data type

Add Answer

Ebun12 answered on May 7, 2020 Popularity 10/10 Helpfulness 2/10

answer sql date/time data type

related date datatype in sql

sql date/time data type

Comment

-1

DATE -- A simple date in YYYY-MM–DD format, with a supported range from ‘1000-01-01’ to ‘9999-12-31’.

DATETIME(fsp) -- A date time in YYYY-MM-DD hh:mm:ss format, with a supported range from ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’. By adding DEFAULT and ON UPDATE to the column definition, it automatically sets to the current date/time.

TIMESTAMP(fsp) -- A Unix Timestamp, which is a value relative to the number of seconds since the Unix epoch (‘1970-01-01 00:00:00’ UTC). This has a supported range from ‘1970-01-01 00:00:01’ UTC to ‘2038-01-09 03:14:07’ UTC.
By adding DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT TIMESTAMP to the column definition, it automatically sets to current date/time.

TIME(fsp) -- A time in hh:mm:ss format, with a supported range from ‘-838:59:59’ to ‘838:59:59’.

YEAR -- A year, with a supported range of ‘1901’ to ‘2155’.

Popularity 10/10 Helpfulness 2/10 Language sql

Source: www.freecodecamp.org

Tags: sql

Link to this answer
Share Copy Link

Contributed on Sep 03 2022

Ebun12

0 Answers Avg Quality 2/10

Closely Related Answers

date datatype in sql

Comment

DATE - format YYYY-MM-DD
DATETIME - format: YYYY-MM-DD HH:MI:SS
TIMESTAMP - format: YYYY-MM-DD HH:MI:SS
YEAR - format YYYY or YY

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: date

Link to this answer
Share Copy Link

Contributed on May 07 2020

Tanishq Vyas

0 Answers Avg Quality 2/10

sql date/time data type

Contents

More Related Answers

sql date/time data type

Closely Related Answers

date datatype in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.