Re: timestamp iin MySQL not compatible to the one in PHP???

So what is the proper function in PHP to convert the MySQL timestamp into a proper format like Sonday, Apr. 20th 2002? Thanx, Andy "Jason Wong" <php-general@gremlins.com.hk> schrieb im Newsbeitrag news:php.db-17490@news.php.net... > 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! > */