December 19, 2013 at 12:01 am
Hi All.
I have a TABLE "TABLE1 " with column STARTDATE and Data Type DateTime2.
It has value of '0020-12-18 00:00:00.0000000'
Now when i m converting it to DATETIME , It is giving me this Error.
Can anyone tell me why.?
ERROR:The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
December 19, 2013 at 12:18 am
got the answer...
Problem is with DateTime.... It support till 1753...... and here in datetime2 we have 0020
🙂
December 20, 2013 at 1:08 pm
Mr. Kapsicum (12/19/2013)
got the answer...Problem is with DateTime.... It support till 1753...... and here in datetime2 we have 0020
🙂
So you have a date value for the Dec. 18 of the year 20 C.E. (Common Era; A.D. (Anno Domini - "Year of Our Lord") - is tres passe) in your database? Is that within the domain for that value, and if so, what is the application? An archaeology database?
Jason Wolfkill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply