General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
SELECT * FROM MtTable WHERE MyDate BETWEEN {^ 1999/5/5} AND {^ 1999/5/12}
HTH
>I would like to have a sql to gather a set of records based on a date field. For example I have several records in my table, say for the month of May I want to only select May 5th thru May 12th. If someone could show me example I would be very appreciative...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only