how to find the record date between reverse date in sql

stellusm...

SOLVED CLOSED ACTIVE ANSWERED
User: stellusmca
Posted: on Apr 26, 2016 08:01 AM
Forum: SQL Server
Answer: 1
Views: 2861

Hi all, I want to know the below date format in sql server how to find the record date between reverse date in sql i have return below code but its showing no record

declare @frdate datetime, @todate datetime
select @frdate='2016-04-01', @todate ='2015-12-01'
select billdate from test where @frdate between @frdate and @todate order by billdate asc

but when i execute below code its working fine,

declare @frdate datetime, @todate datetime
select @frdate='2015-12-01', @todate ='2016-04-01'
select billdate from test where @frdate between @frdate and @todate order by billdate asc

please let me know where i made a mistake, thanks in advance.

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on Apr 26, 2016 08:04 AM
Report

Please refer below Code

SQL

DECLARE @test AS TABLE(Id INT,billdate DATETIME)

INSERT INTO @test VALUES(1,'2015-02-02')
INSERT INTO @test VALUES(2,'2015-03-07')
INSERT INTO @test VALUES(3,'2015-05-04')
INSERT INTO @test VALUES(4,'2015-06-08')
INSERT INTO @test VALUES(5,'2015-08-08')
INSERT INTO @test VALUES(6,'2015-09-02')
INSERT INTO @test VALUES(7,'2016-04-02')
INSERT INTO @test VALUES(8,'2016-04-05')


declare @frdate datetime, @todate datetime

SET @frdate='2016-04-01'
SET @todate ='2015-02-01'

SELECT * FROM @test WHERE billdate BETWEEN @todate AND @frdate
ORDER BY billdate ASC

Screenshot

how to find the record date between reverse date in sql

Company

Explore

Follow us

Contact Us