Here Frank, play with this ....you'll have to add a bit of code to select
your time values, but it will start you down the road. I spent some time
playing with this a couple of years ago, this is taken from a file with the
grand name of "junk.php"!
Miles Thompson
// up here there's code to connect, choose dtabase and select some values.
//The value fetched and stored in $dtAuctionStart is timestamp(14).
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 11:21 AM 2/7/2002 -0600, Frank Miller wrote:
>Hello,
>
> Since I'm the only one who uses php at work I run into a
> little problem and was hoping maybe someone could help me. I've set up a
> Mysql database that has an event time. I've set the field in the table
> as: eventtime time DEFAULT 00:00:00.
>When I go to print the eventtime I'm pulling it out of Mysql with the
>following code snippet
>
> while ($row = mysql_fetch_array($result)) {
> $dateofevent = $row["dateofevent"];
> $sponsor = $row["sponsor"];
> $location = $row["location"];
> $eventtime = $row["eventtime"];
> $contact = $row["contact"];
>
>All of this works. I connect to Mysql and pull out the data.
>
>Then I'm formatting $eventtime with $etime = date("g:i a", $eventtime);
>
>The problem is that when I print $etime in an html table all I get is 6:00
>pm for all the events. When I print $eventtime I get the correct time
>that is stored in Mysql. My question is am I doing this correctly or do I
>need to use another function to format a mysql time.
>
>Thanks in advance.
>
>Frank Miller
>Computer Specialist and Webmaster
>Technology and Distance Education
>Texas A&M University-Texarkana
>2600 North Robison Rd
>Texarkana, Texas 75501
>
>Phone: 903-223-3156
>Fax: 903-223-3139
>Office: 165
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
