"select * from table" question

[Anon]

Is there an example somewhere with code for "select from my_table" where the column contains a date range (select from my_table where date is between user-specified dates). My table is a log table (with columns containing date, user agent, referrer, etc.). I'm asking if there is an example somewhere because I also need the code for a select menu. Thanks

[biggus]

Doris,

I think it'd be
select * from my_table where $date1 < date $date2

HTH

[[deleted]]

and I think you mean
SELECT *
FROM table
WHERE date < '$date2'
AND date > '$date1';

[biggus]

select * from my_table where $date1 < date < $date2

yeah...forgot the second "<".

[biggus]

Sorry about that. Vincent is right. It seems like I used that syntax (minval<$var<maxval) with Oracle. I just tested it on MSSQL and it doesn't work.

[[deleted]]

It also does not work with MySQL, so it looks like it's an oracle-only thing.