WHERE clause with date select

[sd1]

Hello!
i have a table with the following fields:

gameDate
openTime
closeTime

i want to make a query that will select all the games that didn't started yet, which mean the gameDate and openTime are still in the future.

any help will be appriciated

[tuf-web_co_uk]

how about looking for times greater than the current time

i think it would work with now() but if it doesnt and your running it from php then you could just use a var to get a timestamp or something, depending on the format of the fields your using

<?
$sql = "SELECT * from table where gameDate > now()";

// or with a var

$time = date();
$sql = "SELECT * from table where gameDate > ".$time."";
?>

have a try with that, and see what you get 😉

[sd1]

hey!
i'm sorry, i probably didn't explained my self correctly.

what i need to check is:
if the current date & cureent time isn't the needed date

[GreyBoy]

the best way I see of doing that is to check it after the querys been sent.

Maybe a simple if statement???

[sd1]

i did that in first place, but i don't like it. it makes my application really heavy.

thanks a lot for your help

[Sxooter]

select
  * 
from 
  table 
where 
  date_field>'$todays_date'
AND
  time_field>'$right_now';