2.1.09. Time-based data types

  • 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