Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Date and Time Data Types – DATE, DATETIME, TIMESTAMP, TIME, YEAR. What Are Date and Time Data Types?

April 26, 2017Data time TIMESTAMP types year

0

Posted

Date and Time Data Types – DATE, DATETIME, TIMESTAMP, TIME, YEAR. What Are Date and Time Data Types?

1 Answer

0

Posted

• DATE – A date in the range of ‘1000-01-01’ and ‘9999-12-31’. Default DATE format is “YYYY-MM-DD”. • DATETIME – A date with the time of day in the range of ‘1000-01-01 00:00:00’ and ‘9999-12-31 23:59:59’. Default DATETIME format is “YYYY-MM-DD HH:MM:SS”. • TIMESTAMP – A timestamp. The range is ‘1970-01-01 00:00:00’ to partway through the year 2037. Default DATETIME format is “YYYY-MM-DD HH:MM:SS”. • TIME – A time. The range is ‘-838:59:59’ to ‘838:59:59’. Default TIME format is “HH:MM:SS”. • TIME – A time. The range is ‘-838:59:59’ to ‘838:59:59’. Default TIME format is “HH:MM:SS”. • YEAR – A year in 4 digits in the range of 1901 and 2155. Default YEAR format is “YYYY”. How To Calculate Expressions with SQL Statements? There is no special SQL statements to calculate expressions. But you can use the “SELECT expression FROM DUAL” statement return the calculated value of an expression. “DUAL” is a dummy table in the server.