in reply to Re^2: Check Time between 2 other times
in thread Check Time between 2 other times

Absolutely, on both points. I was trying to make the logic as clear as possible for the OP.

(also, I'm not sure whether all SQL dialects support BETWEEN)

Replies are listed 'Best First'.
Re^4: Check Time between 2 other times
by Aristotle (Chancellor) on Nov 03, 2005 at 14:51 UTC

    It’s part of SQL92, at least. MySQL, PostgreSQL, SQLite and Oracle support it. I’d be surprised if any common RDBMS does not.

    Makeshifts last the longest.