select date and time

valen53

i want to select record base on date and time. like..

2004-06-01 12:00pm until 2004-06-02 11:59am.

my date and time was different field. if i select like

SELECT * FROM `match` WHERE mat_date >= '2004-06-01' and mat_time >= '12:00'

only records of the day and more than 12 will select out.

anybody have idea to solve it? thank for reply

i use MySQL 4.0.. so cannot use subquery.

tbach2

Why not combine those two fields into one datetime field? This way you capture all the time info in one field and then you can extract however much info you want, whether date only or time only or any combination of the two.

check out the documentation for date and time functions

valen53

if i combine right now, i need to edit structure and code. quite troublesome..

But if this is the only way, then i need to edit it.

freebie

I think you could do something like this:

$SomeDate='2004-06-01';
$SomeTime='12:00';
$SomeDateTime=$SomeDate.$SomeTime

$SQL="SELECT * FROM `match` WHERE CONCAT(mat_date,mat_time)>=$SomeDateTime";
if(mysql_query($SQL)){
   ///... do something
}

valen53

thank u so much...

it was work..