Page 1 of 1

Comparing 2 datetime in mysql

Posted: Sat Jul 04, 2009 4:38 pm
by xiaomahe
I have one table called member, and i have 2 column called date and date1

how i can substract the 2 of them, date1-date > 0??

i tried TIMEDIFF, but could not make it, because nothing happened in my server

if($dateasd =mysql_query("SELECT * TIMEDIFF ('date1', 'date') FROM member")>0)
{
$login=0;
}

is there something wrong in how i define the variable?

Re: Comparing 2 datetime in mysql

Posted: Sat Jul 04, 2009 6:25 pm
by requinix
How do you write the name of a field (or table, or database) in a SQL query?
How do you write a string value?

Which of those methods did you use for TIMEDIFF?
Which one should you have used?