ansaurus

Question

Answer 1

+4 A:

SELECT * FROM tbl where date_column BETWEEN fromDate and toDate

dcp 2010-09-01 15:38:00

+1 - *9 second* turnaround time

LittleBobbyTables 2010-09-01 15:39:31

Note that both `fromdate` and `todate` will be *inclusive* when using `BETWEEN`

Daniel Renshaw 2010-09-01 15:45:41

i don't want this

2010-09-01 15:57:16

@user415772 - so, what *do* you want?

LittleBobbyTables 2010-09-01 16:12:22

selecting data between a certain date range