selecting data between a certain date range

Question

i have fromdate and todate ..How will i get data that falls in this range ??

Answer 1

SELECT * FROM tbl where date_column BETWEEN fromDate and toDate