X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2025 MariaDB. All rights reserved.

The Ultimate Guide to High Availability with MariaDB
Download Now
  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Solutions
  • Resources
  • Company
  • Pricing
  • Download
Knowledge Base » MariaDB Server Documentation » Columns, Storage Engines, and Plugins » Data Types » Date and Time Data Types
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here View 3 questions

Date and Time Data Types

  • DATE

    The date type YYYY-MM-DD.
  • TIME

    Time format HH:MM:SS.ssssss
  • 5

    DATETIME

    Date and time combination displayed as YYYY-MM-DD HH:MM:SS.
  • 7

    TIMESTAMP

    YYYY-MM-DD HH:MM:SS
  • YEAR Data Type

    A four-digit year.
  • SQL_TSI_YEAR

    Overview See YEAR. EXAMPLES CREATE TABLE sql_tsi_year_example ( example SQL_TSI_YEAR );
There are 3 related questions.
  • ← String Data Types
  • ↑ Data Types ↑
  • Data Types Overview →
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
  • ↑ Data Types ↑
  • Numeric Data Types
  • String Data Types
  • Date and Time Data Types
  • Data Types Overview
  • Geometry Types
  • AUTO_INCREMENT
  • Data Type Storage Requirements
  • AUTO_INCREMENT FAQ
  • NULL Values
  • Server Versions
  • Data Types for MariaDB Server
  • ROW TYPE OF
  • SERIAL
  • TYPE OF
  • Products
  • Solutions
  • Resources
  • Company
  • Pricing
  • Download MariaDB
Subscribe to our newsletter!
  • Legal
  • Privacy Policy
  • Cookie Policy

Copyright © 2025 MariaDB. All rights reserved.