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

2003-09-18 Thread - Edwin -
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

2003-09-17 Thread Cody Phanekham
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