The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Question

declare Expiry datetime now datetime set now  getdate set Expiry  dateaddday3now select Expiry  select  from PostPropertyMaster Where Date lt DateAddhh 17 CastCastExpiry As Date As DateTimeerrorThe conversion of a varchar data type to a datetime data type resulted in an outofrange value

Ali786 · Accepted Answer

sir my error is solved using CONVERTDatetimeDate103 in my table Date column is in ddmmyyyy format select  from PostPropertyMaster  Where CONVERTDatetimeDate103lt DATEADDday 2 GETDATE

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Company

Explore

Follow us

Contact Us