Help needed for TimeStamp conversion between MySQL and PHP

[Andy Hassall]

On Sun, 06 Jul 2003 19:17:58 GMT, "Steven" <xueming@comcast.net> wrote:

>TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend
>on the size, but the timestamp for PHP would be the total seconds from
>1/1/1970( or something like it).
>
>Any easy function to convert them ?

[url]http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions[/url]

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

[Ev0]

"Steven" <xueming@comcast.net> wrote in message
news:GB_Na.51191$926.6117@sccrnsc03...

> TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend
> on the size, but the timestamp for PHP would be the total seconds from
> 1/1/1970( or something like it).
>
> Any easy function to convert them ?
>
> Regards,
> -Steven
>

afaik a unix timestamp IS the number of seconds since 01/01/1970.

in a mysql query you can use FROM_UNIXTIME(unix timestamp here) and
UNIX_TIMESTAMP(mysql date column here)