I'm trying to do a
select convert(datetime, last_changed_dt, 102)
The last_changed_dt column is defined as a timestamp,
and I'm trying to convert the timestamp to a datetime.
The select gives me the following error message:
Domain error during explicit conversion of VARBINARY
value '' to a DATETIME failed.
I have no blank ('') last_changed_dt rows in my table.
I've tried to change the datetime to a smalldatetime.
In this case I don't get error messages, but rows which all
contains "Jan 1 1900 4:16AM". Seems that I get an overflow
(or underflow :-) ) or something.