Home Forums SQL Server 2005 SQL Server 2005 General Discussion Arithmetic overflow error converting expression to data type datetime. RE: Arithmetic overflow error converting expression to data type datetime.

  • November 7, 2008 at 7:58 am

    #895563

    Hi I did a check the non date valuse are zeros ......used isdate to determine non valid dates

    --select distinct Firstdisbursementdate

    --from tbSales

    --where isdate(Firstdisbursementdate) =1

    --select distinct Firstdisbursementdate

    --from tbSales

    --where isdate(Firstdisbursementdate) !=1

    Valid dates Firstdisbursementdate

    20020405

    20041222

    20001111

    20060223

    19991110

    19980425

    19991118

    20080723

    20020813

    Non Valid dates Firstdisbursementdate

    0

    0

    0

    0

    0

    0

    0