You must Sign In to post a response.

Category: .NET

06 Nov 2018 14:32

Joined:	14/01/2014
Level:	Bronze
Points:	90

Points:	3

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

06 Nov 2018 18:09

Joined:	01/01/2011
Level:	Silver
Points:	200

Points:	1

Convert Month to Char like 11 = "November" you will get definitely result.

Submit New Thread

Return to Return to Discussion Forum

Date range between result not getting

About dotnetspider.com

Quick Links

General

Services