hi,
that's the same. If you use between, mysql do the rest for you :
mysql> explain SELECT * FROM passengers WHERE
-> reservation_date_time >= '2005-01-01 12:10:00'
-> AND reservation_date_time <= '2005-05-01 12:10:00';
++-++---+---++
resubmitted
Selon [EMAIL PROTECTED]:
> hi,
> that's the same. If you use between, mysql do the rest for you :
>
> mysql> explain SELECT * FROM passengers WHERE
> -> reservation_date_time >= '2005-01-01 12:10:00'
> -> AND reservation_date_time <= '2005-05-01 12:10:00';
>
++-
Sebastian wrote:
Cory Robin wrote:
I'm trying to return all records between two dates.. The fields are
datetime fields...
Which is better? The following or using BETWEEN? (A little lost here)
SELECT * FROM passengers WHERE
reservation_date_time >= '2005-01-01 12:10:00'
AND reservation_date
Cory Robin wrote:
I'm trying to return all records between two dates.. The fields are
datetime fields...
Which is better? The following or using BETWEEN? (A little lost here)
SELECT * FROM passengers WHERE
reservation_date_time >= '2005-01-01 12:10:00'
AND reservation_date_time <= '2005-05-0
