Could I select a datetime record using date only? I need to show rows containing a particular date. I'm thinking to separate it into two column instead if I couldn't select only date from a datetime.

Yes, use the convert() function like in this post.

commented: thanks +1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.