Dates

[Laeg]

My mind is gone today.

Say I have a table like this

Foo
----------------------------------------------------------------------------------
FooID [int] PK | DateIssued [datetime] | Foo [varchar]| Bar [varchar]

How would I query to say "taking a random date find which
two dates you are between and take the lower datetime value
as the record to return"?

 

[AdaHacker]

Correct me if I'm wrong, but it sounds like that could be re-stated as "find the record with the greatest DateIssued less than or equal to the given date." If so, it's pretty straight-forward. You could just do something like this:

SELECT * FROM Foo WHERE DateIssued = 
    (SELECT MAX(DateIssued) FROM Foo WHERE DateIssued <= :some_date)