General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2014
HYi
I'm taking some data from adatabse with datetime2 fields
the SQL casts these as a datetime
CAST(D.UNAVAILABLE_FROM_DATE AS DATETIME) AS UNAVAILABLE_FROM_DATE
and I'm getting an error
The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
any ideas on the best way to find the offending date . (theres about 200000 records)
at the moment I'm selecting the date without the cast and ordering by the date but there's quite a few of these date casts so I wondered if there was a quicker way.
Thanks
Nick
Thanks
Nick
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only