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!
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
