Re: [PHP] timestamp to english

2003-03-10 Thread Joel Colombo
jim there is no need for the second parameter in Date() for PHP, unless u want something other then current time. Date ('m-d-y') is the same as Date ('m-d-y', Time()) Joel "James Holden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In mysql use > > DATE_FORMAT(FROM_UNIXTIME(tim

Re: [PHP] timestamp to english

2003-03-10 Thread James Holden
In mysql use DATE_FORMAT(FROM_UNIXTIME(time),"%H ... etc") In PHP use echo date("", time()); Read the manuals at mysql.com and php.net. jim Lord Loh. wrote: How do I convert the unix time stamp (the one I get by the time()) to a readable English language time I am getting data from mySQL

Re: [PHP] timestamp to english

2003-03-09 Thread Jason Wong
On Monday 10 March 2003 14:34, Lord Loh. wrote: > How do I convert the unix time stamp (the one I get by the time()) to a > readable English language time > > I am getting data from mySQL by the "now()" function strftime() -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Sou

RE: [PHP] timestamp to english

2003-03-09 Thread John W. Holmes
> How do I convert the unix time stamp (the one I get by the time()) to a > readable English language time > > I am getting data from mySQL by the "now()" function Unix timestamps in PHP and the result of NOW() in MySQL are totally different. You'd use the date() function in PHP to form