Time Specification in SQL-92 date:four digits for the year(1--9999),two digits for the month(1--12), and two digits for the date(1--31). time:two digits for the hour,two digits for the minute,and two digits for the second,plus optional fractional digits. timestamp:the fields of date and time,with six fractional digits for the seconds field. Times are specified in the Universal Coordinated Time,abbreviated UTC(from the French);supports time with time zone. interval:refers to a period of time (e.g.,2 days and 5 hours),without specifying a particular time when this period starts;could more accurately be termed a span. Database System Concepts-6th Edition 25.5 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 25.5 ©Silberschatz, Korth and Sudarshan th Edition Time Specification in SQL-92 date: four digits for the year (1--9999), two digits for the month (1--12), and two digits for the date (1--31). time: two digits for the hour, two digits for the minute, and two digits for the second, plus optional fractional digits. timestamp: the fields of date and time, with six fractional digits for the seconds field. Times are specified in the Universal Coordinated Time, abbreviated UTC (from the French); supports time with time zone. interval: refers to a period of time (e.g., 2 days and 5 hours), without specifying a particular time when this period starts; could more accurately be termed a span