Select from following answers:- The first 2 bytes store the number of days after January 1, 1900.
- The second 2-bytes store the number of seconds since midnight
- Dates range from January 1, 1900 through June 6, 2079.
- SQL Server 2000 stores SMALLDATETIME values as two 2-byte integers
- All Above
All are valid except second option, SMALLDATETIME data type stores number of minutes since midnight in second 2-bytes
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator