how to eliminate the time ?

[zgkhoo]

given

$row[Expireddate]= 2007-12-23 00:00:00 

i wanna compare it with date("Y-m-d")....but the above variable contain time..which not compatible.

thks...

 

 

[Daniel0]

$date = substr($row['Expiredate'], 0, 10);

Will get the date part of string.

 

You could also use strtotime() to convert it to a UNIX timestamp.

[kenrbnsn]

You can also use the explode() function:

<?php
list($date , $dmy) = explode(' ',$row['Expiredate']);
?>

 

Personally, since we're dealing with dates, I would use the date() and strtotime() functions:

<?php
$date = date('Y-m-d',strtotime($row['Expiredate']));
?>

 

You can also use MySQL directly to return the correct format, but I don't know the correct incantation off the top of my head.

 

Ken