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.
Sunday, February 14, 2010
CAST with SMALLDATETIME
at 8:41 PM
Labels: SQL Server, SQL Server Test, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment