I'm trying to extract all records for a given date from an SQL Server 7 database. Records are stamped with a timestamp like this: "1/18/01 10:53:31 AM"
Queries using "WHERE timestamp LIKE '1/18/01'" are not working.
What's the best way to select all records for a given date using the timestamp I have?
Queries using "WHERE timestamp LIKE '1/18/01'" are not working.
What's the best way to select all records for a given date using the timestamp I have?