Programmer Guide : Data types : Constraints of the Gregorian calendar
  
Constraints of the Gregorian calendar
The following table contains the Gregorian calendar constraints for date and datetime data types.
Value
Requirement
month field
Must be between 1 and 12, inclusive.
day field
Range must be from 1 through the number of days in the month, which is determined from the values of the year and months fields and can be 28, 29, 30, or 31. A leap year can also affect the number of days in the month.
hour field
Must be between 0 and 23, inclusive.
minute field
Must be between 0 and 59, inclusive.
trailing seconds field
Must be between 0 and 61.9(n), inclusive, where n specifies the number of digits at the place of "9" and the value of n is the fractional seconds precision. The range of seconds permits a maximum of two leap seconds to maintain synchronization of sidereal time.
See also
Data types