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
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.