SELECT WHERE Statement on Timestamp Field 1

[AdmanOK]

I have a table that stores calendar events with timestamp field for the start time and end time. I am trying to write an ASP page that displays these fields, however I am not sure how to go about this. I tried something like:

SELECT * FROM events WHERE eventstarttime LIKE '20050816%'

to get all the events for 8/16/2005 but this did not display any records, even though there are events in the calendar for that date.

What would be the correct syntax for this query?

 

[r937]

WHERE eventstarttime >= '2005-08-16'
AND eventstarttime < '2005-08-17'





r937.com | rudy.ca

 

[AdmanOK]

Thanks for the quick reply Rudy. I figured that was the answer, I just didn't want to have to calculate the date for the following day to include as an upper limit in the SQL query.

 

[r937]

do take the time to write the expression for the next day, because that form of the query will allow the optimizer to utilize an index on the timestamp column -- other sql constructions may not

r937.com | rudy.ca