KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to retrieve records from table by knowing the date in column contains date and time. Suppose I have table called t1 which contains only two column name and date respectively. The data stored in column date like this 8/3/2010 12:34:20 PM . I want to retrieve this record by this query for example (note I don't put the time): Select * From t1 Where date="8/3/2010" This query give me nothing ! How can I retrieve date by knowing only date without the time?
Tags (comma-separated)
Save Edits
Cancel