> For the complete documentation index, see [llms.txt](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/main-1/sql/intermediate-sql/more-sql-data-types-and-schemas.md).

# More SQL Data Types and Schemas

The following are some additional data types in SQL:

* **date**: Dates, containing a (4 digit) year, month and date
  * Example: date ‘2005-7-27’
* **time**: Time of day, in hours, minutes and seconds
  * Example: time ‘09:00:30’ time ‘09:00:30.75’
* **timestamp**: date plus time of day
  * Example: timestamp ‘2005-7-27 09:00:30.75’
* **interval**: period of time
  * Example: interval ‘1’ day
  * Subtracting a date/time/timestamp value from another gives an interval value
  * Interval values can be added to date/time/timestamp values