For AI agents: a machine-readable documentation index is available at https://docs.starrocks.io/llms.txt. Every documentation page is also available as Markdown by appending ".md" to its URL.

Skip to main content

🎉️ Watch on demand: StarRocks Summit 2025 🎉️

StarRocksDocs

Latest-4.1
4.0
Stable-3.5
Archived versions
3.4
3.3
3.2
3.1

English
中文
日本語

StarRocks Summit 2025 Release Notes

Slack

Introduction to StarRocks
Quick Start
Best Practices
Deployment
Table Design
Data Loading
Data Unloading
Data Lakes
Query Acceleration
Integrations
Administration
Reference
FAQ
Benchmarks
StarRocks
developers

Reference
Data types
Date and Time

Version: 4.0

Date and time data types

📄️ DATE

DATE type. The value range is ['0000-01-01', '9999-12-31'] and the default format is YYYY-MM-DD.

📄️ DATETIME

Date and time type. The value range is ['0000-01-01 0000', '9999-12-31 2359'].

StarRocks.io
Privacy policy

Docs built with Docusaurus.

Rocky the happy otter

StarRocks Assistant

AI generated answers are based on docs and other sources. Please test answers in non-production environments.