Ad Unit (Iklan) BIG

how to selected date validate from date range in sql server

create table #fueldt
(
 [id] [int] identity(1,1) not null,
 [vendorname] [nvarchar](50)  null,
 [fromdate] [datetime],
 [todate] [datetime],
 [fuelprice] [decimal] (18,2)
)
go
insert into  #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor1', getdate()-23, getdate(),78)
insert into  #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor2', getdate()-13, getdate(),72)
insert into  #fueldt ([vendorname], [fromdate], [todate],[fuelprice]) values (n'vendor3', getdate()-18, getdate(),75)
go

select
*     
from #fueldt fuel  
where  (  
  convert(date,'7 feb 2020') between convert(date,fuel.fromdate) and convert(date,fuel.todate) 
)
select * from #fueldt 

Post a Comment

0 Comments