On Tuesday 05 March 2002 05:11 pm, Andy wrote: > So what is the proper function in PHP to convert the MySQL timestamp into a > proper format like Sonday, Apr. 20th 2002?
<?php echo date("D. M. d, Y") ?> > Thanx, > > Andy > > > "Jason Wong" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > news:[EMAIL PROTECTED]... > > > On Wednesday 06 March 2002 04:31, Andy wrote: > > > Hi there, > > > > > > I am playing around with the timestamp functions. I created a timestamp > > > with mysql ( the row is timestamp) > > > and do reformat this thing after selecting with php in the folowíng > > > way: > > > > > > $date_posted[$i] = strftime("%A, %d-%m-%Y %R", $date_posted[$i]); > > > > > > This always returns Tuesday, 19-01-2038 but the mysql timestamp says: > > > 20020305211704 > > > > They return the time in different formats. Read the MySQL manual then > > read the PHP manual (or vice-versa). > > > > The MySQL timestamp is human readable. So in your example above: > > > > 20020305211704 ==> 2002-03-05 21:17:04 > > > > time() in PHP is the number of seconds since the Unix Epoch. > > > > -- > > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > > > /* > > But, officer, he's not drunk, I just saw his fingers twitch! > > */ -- Ken Thompson, North West Antique Autos Payette, Idaho Email: [EMAIL PROTECTED] http://www.nwaa.com Sales and brokering of antique autos and parts. Linux- Coming Soon To A Desktop Near You Registered Linux User #183936 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php