SET DATEFORMAT dmy
GO
SELECT *
FROM LGP_Review
WHERE Date > (CAST('01/02/07' AS datetime))
Strin2Date
Нужно конвертировать поле из nchar в (small)datetime
написал вот так:
SELECT *
FROM LGP_Review
WHERE Date > (CAST('01/02/07' AS datetime))
Комп. дает:
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Что можно сделать?
Где моя ошибка?
MS SQL Server 2000
Часть таблицы:
Code Review UserName Date CurrentDate
----------- ----------------------------------------------------------------------------------------------9445 Testing:
The mouse works great. If I compared it to the older MX se
ries mice, it clearly stands above the rest of the line. When compar
ed to the G7, I cannot see this mouse as a successor. It is a totall
y different mouse with different areas of in rico75 24/01/2007 18:36:03 NULL
9445 Conclusion:
You must feel the mouse before you buy it. Purchasing
an input device is an important decision and without testing the dev
ice, you may end up with some you do not like. The MX Revolution may
not be revolutionary, but it is a great mou rico75 24/01/2007 18:35:47 NULL
написал вот так:
SELECT *
FROM LGP_Review
WHERE Date > (CAST('01/02/07' AS datetime))
Комп. дает:
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
Что можно сделать?
Где моя ошибка?
MS SQL Server 2000
Часть таблицы:
Code Review UserName Date CurrentDate
----------- ----------------------------------------------------------------------------------------------9445 Testing:
The mouse works great. If I compared it to the older MX se
ries mice, it clearly stands above the rest of the line. When compar
ed to the G7, I cannot see this mouse as a successor. It is a totall
y different mouse with different areas of in rico75 24/01/2007 18:36:03 NULL
9445 Conclusion:
You must feel the mouse before you buy it. Purchasing
an input device is an important decision and without testing the dev
ice, you may end up with some you do not like. The MX Revolution may
not be revolutionary, but it is a great mou rico75 24/01/2007 18:35:47 NULL
Спасибо, большое! Все заработало!