Date/Time
Core provides three date and time-related field types:
- DateTime
- Date
- Time
These fields are used to store temporal data at different levels of precision.
1. DateTime
- Stores: Both date and time
- Format:
YYYY-MM-DD HH:MM:SS - Example:
2026-05-05 14:30:00
Use DateTime when
You need a full timestamp.
Typical DateTime use cases
- Order creation time
- Message sent time
- User login events
2. Date
- Stores: Date only (no time component)
- Format:
YYYY-MM-DD - Example:
2026-05-05
Use Date when
The time of day is not relevant.
Typical Date use cases
- Birthdays
- Holidays
- Due dates
3. Time
- Stores: Time only (no date component)
- Format:
HH:MM:SS - Example:
14:30:00
Use Time when
You need a time independent of a specific date.
Typical Time use cases
- Opening hours
- Alarm times
- Daily schedules