strip dashes in text

[samoht]

Hello again,

 

I know this must be easy but I couldn't find an answer on google.

 

I have a date returned from my db that is formated like 2007-07-10

I would like to hyper link that to the proper calendar page but I need the format to be 20070710

e.g. w/o the dashes

 

How can I do this easily??

 

Thanks

[trq]

<?php

  $d = '2007-07-10';
  $d = str_replace('-','',$d);

?>

[per1os]

www.php.net/strtotime

 

www.php.net/date

 

www.php.net/str_replace

 

or www.php.net/explode

 

<?php
$date = '2007-07-10';
$date_array = explode($date);
$new_date = implode('',$date_array);

echo $new_date
?>

 

there the explode/implode example.

[Wildbug]

Why not select it from the database in the format you want it in the program?

 

mysql> SELECT date_or_datetime_col, DATE_FORMAT(date_or_datetime_col,'%Y%m%d') FROM tbl;
+---------------------+--------------------------------------------+
| date_or_datetime_col| DATE_FORMAT(date_or_datetime_col,'%Y%m%d') |
+---------------------+--------------------------------------------+
| 2007-04-30 20:52:25 | 20070430                                   |
| 2007-04-27 12:00:00 | 20070427                                   |
| 2007-01-01 12:00:00 | 20070101                                   |
| 2006-05-01 00:00:00 | 20060501                                   |
| 2007-01-02 13:00:13 | 20070102                                   |
| 2007-03-31 09:00:00 | 20070331                                   |
| 2007-03-30 01:00:00 | 20070330                                   |
| 2007-05-01 00:00:00 | 20070501                                   |
+---------------------+--------------------------------------------+
8 rows in set (0.00 sec)

[samoht]

Thanks Guys!

 

I knew it was easy 

 

All of the suggestions work - but the simple string replace seems best for now. glad to know the other methods though!

 

Thanks again