Re: Re[2]: [PHP] MySQL timestamp to desired date function

Hi, Tom Rogers <[EMAIL PROTECTED]> wrote: [snip] > what database are you using? [/snip] See "Subject" line? Or, is this a trick question? :) (Sorry, couldn't resist :) ) - E - __ Do You Yahoo!? Yahoo! BB is Broadband by Yahoo! http://bb.yahoo.co.

RE: Re[2]: [PHP] MySQL timestamp to desired date function

I'd have to agree with Tom, it would be better to do the formatting using the DB since MySQL stores its timestamp differently than the UNIX timestamp. however, if you really want to do it in PHP you can use MySQL's function UNIX_TIMESTAMP() to convert the db timestamp to a unix timestamp, then u

Re[2]: [PHP] MySQL timestamp to desired date function

Hi, Thursday, September 18, 2003, 2:53:53 PM, you wrote: CA> Thanks Tom, but using only the strtotime() and later the date() CA> functions, the page throus the following error: CA> Warning: unexpected error in date() in e:\wwwroot\videoteca\index.php on CA> line 52 CA> Now my code looks like thi