in a table having the fields of starttime & endtime ,I want to fetch only the records having starttime & endtime of same days.
waqar100 0
Newbie Poster
Recommended Answers
Jump to PostOR
SELECT * from tablename where
CONVERT(VARCHAR(10), starttime, 105) =CONVERT(VARCHAR(10), endtime, 105)
All 3 Replies
urtrivedi 276
Nearly a Posting Virtuoso
select * from tablename where
day(starttime)=day(endtime)
and month(starttime)=month(endtime)
and year(starttime)=year(endtime)
urtrivedi 276
Nearly a Posting Virtuoso
OR
SELECT * from tablename where
CONVERT(VARCHAR(10), starttime, 105) =CONVERT(VARCHAR(10), endtime, 105)
debasisdas
commented:
yes , that should work perfectly fine. +8
buddylee17
commented:
Good examples! +4
buddylee17 216
Practically a Master Poster
urtivedi has given you 2 good examples that will work.
In SQL Server 2008, there's a 3rd option which utilizes the new date datatype:
SELECT * from tablename where
CAST(starttime AS date) = CAST(endtime AS date)http://msdn.microsoft.com/en-us/library/ms186724.aspx#DateandTimeDataTypes
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.