You must Sign In to post a response.
  • Category: .NET

    Date range between result not getting

    Hi,

    I have 'compdate' column value as 2018-11-06 09:27:17.000 and passing values to fromdate and todate range as '06/11/2018' and '06/11/2018'

    I tried below query but no output came.

    select comp_date from complaints where comp_date between '06/11/2018' and '06/11/2018'

    can you correct my query.

    Regards,
    Ayesha
  • #769799
    Convert Month to Char like 11 = "November" you will get definitely result.


  • Sign In to post your comments