Home Forums SQL Server 2008 SQL Server 2008 - General Count differs while using the date values RE: Count differs while using the date values

  • April 28, 2016 at 11:51 pm

    #1875471

    pstanand (4/28/2016)

    Hi,

    So shall I use the below one? Suggest me.

    select count(1) from sap_plant

    where lastupdate >='20160419'

    and lastupdate <'20160428';

    Thanks

    Regards,

    pstanand

    Yes.

    That would be correct.

    If you use paramerters you may wish to user following construction:

    where lastupdate >=@StartDate

    and lastupdate < DATEADD(dd, 1, @EndDate);

    @EndDate here would be the last date to be included into the query: 27 Apr 2016

    _____________
    Code for TallyGenerator