How to select records with today's event? I have a column that is set to smalldatetime. I need to select those that have a row of today's event.
AngelicOne
4
Posting Whiz
Recommended Answers
Jump to PostHi,
Simply use this example:
SELECT * FROM <TABLENAME> WHERE convert(varchar(10),<DATETIMECOLUMNNAME>,101) = convert(varchar(10),GETDATE(),101)
All 3 Replies
NextCom
8
Light Poster
AngelicOne
4
Posting Whiz
Momerath
1,327
Nearly a Senior Poster
Featured Poster
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.