Snippets Calendars Dates
Calendars Dates
MySQL Timestamp(14) to Human readable (HTML format) String
by: Elliott Edwards
|
July 13, 2001
Version: 1.0
Type: Function
Category: Calendars/Dates
License: GNU General Public License
Description: A simple converter that does a helpful (and eye-strain preventing) conversion from a MySQL Timestamp(14) to a much easier to read format. Brought to you by www.hachisoft.com
<?
_/_/_/_/_/_/_/_/_/_/_/_/
_/ _/
_/ www.hachisoft.com _/
_/ Presents: _/
_/ _/
_/_/_/_/_/_/_/_/_/_/_/_/
//MySQL Timestamp(14) to Human readable (HTML) Snippet
//by Elliott Edwards (eedwards@hachisoft.com)
//Standard Disclaimer:
//This code snippet is provided AS IS. Neither Elliott Edwards nor Hachisoft are
//to be held responsible for any failures or security flaws in this code. Use at your
//own risk.
//Distribution: If you want to use this code commercially or share it with friends,
//Go Ahead. Just kindly give credit where it is due: (Elliott Edwards & Hachisoft). Thanks
//If you appreciate this snippet or have comments, email eedwards@hachisoft.com
//Updates and improvements are already in the works. see www.hachisoft.com for more details.
//TO INSTALL: Paste this function into your php file.
//Begin actual code///////
//////////////////////
//Input: A MySQL TIMESTAMP(14)
//Output: A human-readable string version (with HTML)
function parseTimeStamp($timestamp)
{
$months = array(1=>'Jan',2=>'Feb',3=>'Mar',4=>'Apr',5=>'May',6=>'Jun',7=>'Jul',8=>'Aug',9=>'Sep',10=>'Oct',11=>'Nov',12=>'Dec');
//Courtesy of snippet 245 by igork
list($year, $month, $date, $hour, $min, $sec) = sscanf($timestamp, "%4d%2d%2d%2d%2d%2d");
$ampm='AM';
if ($hour>=12)
$ampm='PM';
$hour = $hour % 12;
if ($hour==0)
$hour = 12;
if ($min < 10)
$min = "0$min";
if ($sec < 10)
$sec = "0$sec";
return "$hour:$min:<SMALL>$sec $ampm</SMALL> {$months[$month]} $date, $year";
}
?>
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
