hi,
I am getting problem while selecting records for below mentioned query.
Select Min(TotalAvalablity) as TotalAvalablity from htl_FDRoomAvailability where REPLACE(CONVERT(varchar(50),ReserveDate, 101), ' ', '-')>='12/31/2009' and REPLACE(CONVERT(varchar(50),ReserveDate, 101), ' ', '-')<='01/01/2010'
Please any one help me why its showing null.If ReserveDate is between same year then its giving correct result.
Thanks,
Soumya
Loading
Rekha SinghPosted Dec 30, 2009, 4:39 AM
Select * from test
where
REPLACE(CONVERT(varchar(50),Date, 102), ' ', '-')>='2009.12.25'
and
REPLACE(CONVERT(varchar(50),Date, 102), ' ', '-')<='2010.01.15'
*****************************************
Please mark it Accepted if u find it helpful.
soumya shanbhagPosted Dec 30, 2009, 4:52 AM
Thank u so much its working fine.
Santhosh NPosted Dec 30, 2009, 4:30 AM