- Date and Time
- DATE
- Ten positions, components YYYY-MM-DD
- TIME
- Eight positions, components HH:MM:SS
- TIME(i)
- Time fractional seconds precision
- Adds i+1 positions
- TIMESTAMP
- optionally WITH TIME ZONE
- Very sensitive to syntactical ambiguities
- day/month/year/hour/minute separators
In Focus
2.1.09. Time-based data types