Compare dates in SQL

I have a table with a column of only dates (without the time). In an SQL statement, how would I compare the dates in the table with an inputted date.

Here's an idea of what I'm looking for

SELECT * FROM table WHERE date > (an inputted date) AND date < (an inputted date)

What database are you using?

How is your date column defined?

If you select your date column from the table, what is the format of the result?

Looks good to me.

Just make sure that the date format for your inputted date is the same format as in the database.

Either that or BETWEEN '01-Jan-90' AND '30-Jan-90', just as an example.