Here, play with this. dtAuctionStart is a MySQL date field, so substitute 
your own connection and var.
Have fun - Miles Thompson

Some messing about with dates <br>
=============================<br>

<?
echo $dtAuctionStart, "<br>";
echo date ("Y-m-d", $dtAuctionStart ), "<br>";
//$strDate =  $dtAuctionStart ;
echo "dtAuctionStart  : $dtAuctionStart";

$year =                 substr ($dtAuctionStart, 0, 4);
$month =        substr( $dtAuctionStart, 4, 2 );
$day =          substr ($dtAuctionStart, 6, 2 );
Echo "dtAuctionStart in m-d -y : $month-$day-$year <br>";

$workdate = getdate( $dtAuctionStart );
echo " Workdate Year:", $workdate["year"],"<br>";
?>

Ereg Stuff <br>
==========<br>
<?
if (ereg ("([0-9]{4})([0-9]{1,2})([0-9]{1,2})", $dtAuctionStart, $regs))
{
         echo "Auction Start:  $regs[1]-$regs[2]-$regs[3] <br><br>";
}
else
{
         echo "Bad date format. <br>";
}

//echo gmdate ("Y-m-d", time()), "<br>";
echo date ("M-d-Y", mktime (0,0,0, $month, $day, $year));
// echo date ("M-d-Y", mktime (0,0,0,12,32,1997));


echo "<br>Local date: <br> " ;
echo date ("M d Y H:i:s", time()), "<br>";
echo date ("M d Y H:i:s", time()), "<br>";
echo "Greenwich date: <br>";
echo gmdate ("M d Y H:i:s", time()), "<br>";
echo gmdate ("YmdHis", time()), "<br>";

?>

At 09:35 PM 12/10/2001 -0600, phantom wrote:
>What would be an easy what to format a date value into month day year??
>I want to specially display a date stored in mysql in date format
>YYYY-MM-DD
>
>The manual says: string date (string format, int [timestamp])
>
>I tried $FormattedDate = date("F y, Y",${StoredDate})
>
>1999-04-15 spit out December 31, 1969 when I had hoped for April 15,
>1999.
>
>Apparently YYYY-MM-DD is not a valid timestamp... i tried mysql formats
>of timestamp(8) and timestamp(14) and that didn't work either
>
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to