In this chapter you will learn:
What is date data type?
Types of date data type
What is date data type?
Sometimes we need to store the date value in our database records then the date data type used to store the date in the specific database or table. There are so many date data types by which we can store date in different format.
| Data types | Range | Used to store | Storage (Bytes) |
|---|---|---|---|
| datetime | January 1, 1753, through December 31, 9999 | Date and time data | 8 |
| smalldatetime | January 1, 1900, through December 31, 2079 | Date and time data | 4 |
| date | January 1, 0001, through December 31, 9999 A.D. | Date data | 3 |
| datetime2 | January 1, 0001, through December 31, 9999 A.D. | Date and time data | 6 to 8 |
| datetimeoffset | January 1, 0001, through December 31, 9999 A.D. | Time zone adware date and time data | 10 |
| time | 00:00:00.0000000 through 23:59:59.9999999 | Time data | 5 |
| timestamp | Maximum storage size of 8 bytes | Unique number in a database that is updated every time a rows that contains time stamp is inserted or updated | 8 |
| Year | 1970 to 2069 | Store year in two or four digit format |
SUMMARY
All date data types are given in this chapter for your help to leran easily. In the next chapter all remaining data type of sql are given into other data types category.