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

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

2003-09-17 Thread Tom Rogers
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

RE: [PHP] MySQL timestamp to desired date function

2003-09-17 Thread Cesar Aracena
cted results. can we get some sample data from the lugar_lastinsert field? > -Original Message- > From: Cesar Aracena [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 September 2003 14:39 > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL timestamp to desired date functio

RE: [PHP] MySQL timestamp to desired date function

2003-09-17 Thread Cody Phanekham
mple data from the lugar_lastinsert field? > -Original Message- > From: Cesar Aracena [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 September 2003 14:39 > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL timestamp to desired date function > > > Hi all, > > I ha

RE: [PHP] MySQL timestamp to desired date function

2003-09-17 Thread Cesar Aracena
\de Y H:i:s", $date1); Any ideas? Thanks, Cesar Aracena www.icaam.com.ar -Mensaje original- De: Tom Rogers [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 18 de Septiembre de 2003 01:48 a.m. Para: Cesar Aracena CC: [EMAIL PROTECTED] Asunto: Re: [PHP] MySQL timestamp to desired date fu

Re: [PHP] MySQL timestamp to desired date function

2003-09-17 Thread Tom Rogers
Hi, Thursday, September 18, 2003, 2:38:50 PM, you wrote: CA> Hi all, CA> I have a a timestamp in a DB (14 digits) that I want to display like I CA> want in my pages. I tried to use strtotime, mktime and date functions CA> with no success... it always return the current timestamp instead of the CA

[PHP] MySQL timestamp to desired date function

2003-09-17 Thread Cesar Aracena
Hi all, I have a a timestamp in a DB (14 digits) that I want to display like I want in my pages. I tried to use strtotime, mktime and date functions with no success... it always return the current timestamp instead of the one I have stored. This is what I've done so far: for ($x = 0; $x <