What will be the output of the following script in SQL Server 2008?
SELECT CAST(0 AS DATETIME2 )
A. 1900-01-01 00:00:00.0000000
B. 0001-01-01 00:00:00.0000000
C. 1753-01-01 00:00:00.0000000
D. An error will be generated: "Explicit conversion from data type int to datetime2 is not allowed."
E. An error will be generated:"Type DATETIME2 is not a defined system type."
Answer:[D]
Highlight to find out the answer.
Monday, March 1, 2010
CAST with DATETIME2
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment