How to compare these 2 dates

maskme

Hi to All

Hw wud i compare whether the date:

//I'm writing it in form of Year-Month-Date inorder to store in mysql database field which has data type Date

$datepi = "$yearpi-$monthpi-$datepi";

//is not equal or less then

$datevi = "$yearvi-$monthvi-$datevi";

Please Help!

THanx
Yusuf

monexx

Hi Yusuf,

There is an article about date manipulation:

http://www.phpbuilder.com/columns/akent20000610.php3

HTH

S. Breton

the_Igel

As you may have noticed, MySQL uses not very common time format. The reason is simple: when you compare two dates in his format (as strings), you get the result as if compared them as dates. So the answer is: you need to do nothing to compare them, ust write if ($date1 >= $date2) and everything is OK.

monexx

I am sorry, i missed the question.

You should use the date_format() function from mysql.

I never used it (since i never used MySQL) but it should work:

select date_format(datefield, '%e-%c-%Y') from table

and

insert into table (datefield) values (date_format(date, '%Y-%c-%e')

so that way, you can convert from the MySQL to PHP format (well, any format you want, refer to the manual for more info).

have fun

S. Breton

maskme

Thanx to all of you for your help!