View Single Post
  #2 (permalink)  
Old 08-11-2004, 07:43 PM
redcircle's Avatar
redcircle redcircle is offline
WebProWorld Veteran
 

Join Date: Aug 2003
Location: Grand Rapids, MI USA
Posts: 553
redcircle RepRank 0
Default

Assuming you are using PHP you can convert the MySQL into a unixtimestamp and output from there.

Code:
<?php
$unix = strtotime('2004-08-10 22:33:21');  //puts the mysql datetime into unix timestamp this probably can be done within mysql also
$datetime = date('F j Y h:ia',$unix); //removes seconds and adds either am/pm accordingly if you want 24hr time use a capital H for hour
?>
__________________
www.squitosoft.com - PHP development site. featuring Squito Gallery. a php driven photo gallery.
www.rgfx.net - Specializing in Internet solutions, including Html authoring, Interactive Web sites, 3D/2D Graphics and animation.
Reply With Quote