Gerald,
If you're getting an error updating a smalldatetime column with a
datetime value, you probably have a datetime value that is outside the
range of the type smalldatetime. Can you look for such values this way?
select
datetimecolumn
from sourceOfColumn
where datetimecolumn < '19000101'
or datetimecolumn >= '20790607'
Steve Kass
Drew University
[quoted text, click to view] Gerald Baeck wrote:
>Is there a way to convert a datetime field to a smalldatetime field. I try
>to Update the filed with a cast or convert function it htrows an overflow
>exception, also changing the datatype via mmc is not possible.
>
>thx, Gerald.
>
>
>
thx, that was it
"Steve Kass" <skass@drew.edu> schrieb im Newsbeitrag
news:OVWwIfz1EHA.1524@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view] > Gerald,
>
> If you're getting an error updating a smalldatetime column with a
> datetime value, you probably have a datetime value that is outside the
> range of the type smalldatetime. Can you look for such values this way?
>
> select
> datetimecolumn
> from sourceOfColumn
> where datetimecolumn < '19000101'
> or datetimecolumn >= '20790607'
>
> Steve Kass
> Drew University
>
> Gerald Baeck wrote:
>
>>Is there a way to convert a datetime field to a smalldatetime field. I try
>>to Update the filed with a cast or convert function it htrows an overflow
>>exception, also changing the datatype via mmc is not possible.
>>
>>thx, Gerald.
>>
>>
