[SOLVED] Cutting Strings

[wattsup88]

I have a date that i need to work with, but in my database it is entered like 2006-03-07... i need to know how to "cut" all of the hyphens out of the date returned by the database... that way i can write a script to delete all of the rows with an expired date...

Thanks,

Jacob

[paul2463]

try using <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html">DATE_FORMAT()</a> you can the format the date exactly as you want it when you pull it from the database.

[taith]

$date='2006-03-07';
$date=str_replace("-", "", "$date");

echo $date; #20060307

edit: just as a note its MUCH easier to have date(z) in the database, expire, remove that way... ;-)

[wattsup88]

Thanks so much guys oh and just so you know taith I won't be using the database I'm creating it for someone else... I of course want it to be user friendly, and I don't always have the knowledge to make it user friendly and practical. So I figured this would be the best way... again thanks for the help...