Sunday, February 14, 2010

CAST with SMALLDATETIME

What will be the result of the following statement?

SELECT CAST(-1 AS SMALLDATETIME)


A. 1900-01-01 00:00:00.000
B. 1899-01-01 00:00:00.000
C. 1899-12-31 00:00:00.000
D. 1752-01-01 00:00:00.000
E. 1752-12-31 00:00:00.000
F. The system will generate an error. Arithmetic overflow error converting expression to data type smalldatetime.

Answer:[F]
Highlight to find out the answer.

No comments:

Post a Comment