AW: [PHP-DB] Formatting timestamp dates retrieved from MySQL

Have you checked the regular expression functions? I don't have the exact syntax at hand now, but it might be something like: if(ereg("([0-9]{2,4})-([0-9]{2})-([0-9]{2})", $date, $parts)) { $new_date = $parts[3]."-".$parts[2]."-".$parts[1]; } -----Ursprüngliche Nachricht----- Von: Miles Thompson [mailto:milesthompson@sprint.ca] Gesendet: Mittwoch, 11. Oktober 2000 17:11 An: php-db@lists.php.net Betreff: [PHP-DB] Formatting timestamp dates retrieved from MySQL Date formatting has always been ugly, and the MySQL timestamp returns a yyyymmdd, rather than the mmddyyyy used by the PHP date formatting functions. Is there an alternative to this, rather ugly, extraction and formatting to get yyyy-mm-dd rather than a tight yyyymmdd? I know I could do the formatting in the "select", but as the number of fields we may wish to fetch may vary, I'm happier sticking with the "*" at present. Here's the ugly code, dtAuctionStart is one of several timestamp fields: $sql = "SELECT * FROM item order by cItemId"; $result = mysql_query($sql,$db); if ( mysql_num_rows( $result) ) { //bunch of table formatting stuff while ($myrow = mysql_fetch_array($result)) { // table formatting stuff surrounds this ... echo substr( $myrow[dtAuctionStart], 0, 4), "-"; echo substr( $myrow[dtAuctionStart], 4, 2 ), "-"; echo substr( $myrow[dtAuctionStart], 6, 2 ); } } Thanks for looking - Miles Thompson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net