SQL - Date datatype

Data System Architecture

About

A SQL DATE is a sql datatype that represents:

  • a date
  • at the day level (ie without hour, minutes, …)
  • and contains therefore the <datetime field>s YEAR, MONTH, and DAY;

Function

See date time function




Discover More
Data System Architecture
SQL - Data Type (Column Type)

The Data Type of a column in SQL. They are defined in the ANSI/ISO SQL standard but may vary from sql engine (database) to another. The below table shows you the history of the data type in the ANSI...
Sqlite Banner
SQLite - Date

The date data type in SQLite context does not exist. It is not an affinity. SQLite are capable of storing dates and times with the following data type (affinity) as: TEXT with ISO8601 strings (“YYYY-MM-DD...



Share this page:
Follow us:
Task Runner