on echoing $timestamp i m getting "Fri Jan 28 19:53:09 2005" but on echoing $date i m getting 1970-01-01. also i m getting full info. by phpinfo() i m using php 4.2.2 , apache 2.0 and rad hat 9. with best wishes balwant On Tue, 2005-02-01 at 12:40, graeme wrote: > what output do you get from the following? > > <?php > $timestamp = "Fri Jan 28 19:53:09 2005"; > echo $timestamp ."<br>"; > $date = date("Y-m-d",strtotime($timestamp)); > echo $date ."<br>"; > phpinfo(); > ?> > > graeme wrote: > > > The code works fine on my system, so what version of php are you using > > and what is your operating system? > > > > graeme. > > > > Balwant Singh wrote: > > > >> i just copy your code and paste into a test file. > >> <? > >> $timestamp = "Fri Jan 28 19:53:09 2005"; > >> $date = date("Y-m-d",strtotime($timestamp)); > >> echo $date; > >> > >> ?> > >> > >> with best wishes > >> balwant > >> > >> > >> > >> On Tue, 2005-02-01 at 10:33, Bastien Koert wrote: > >> > >> > >>> pls post relevant code > >>> > >>> bastien > >>> > >>> > >>> > >>>> From: Balwant Singh <balwantsingh@xxxxxxxxxxxxx> > >>>> Reply-To: balwantsingh@xxxxxxxxxxxxx > >>>> To: Bastien Koert <bastien_k@xxxxxxxxxxx> > >>>> CC: php-db@xxxxxxxxxxxxx > >>>> Subject: RE: timestamp > >>>> Date: 01 Feb 2005 10:13:40 +0530 > >>>> > >>>> dear bastien > >>>> > >>>> thanks for the reply... but i checked it again but it is giving only > >>>> 1970-01-01. is something else needs to be done. > >>>> > >>>> with best wishes > >>>> balwant > >>>> > >>>> > >>>> > >>>> On Mon, 2005-01-31 at 19:46, Bastien Koert wrote: > >>>> > >>>> > >>>>> This code : > >>>>> > >>>>> <? > >>>>> $timestamp = "Fri Jan 28 19:53:09 2005"; > >>>>> > >>>>> $date = date("Y-m-d",strtotime($timestamp)); > >>>>> > >>>>> echo $date; > >>>>> > >>>>> ?> > >>>>> > >>>>> gave me this result > >>>>> > >>>>> 2005-01-28 > >>>>> > >>>>> Exactly as it should. > >>>>> > >>>>> Bastien > >>>>> > >>>>> > >>>>> > >>>>>> From: Balwant Singh <balwantsingh@xxxxxxxxxxxxx> > >>>>>> Reply-To: balwantsingh@xxxxxxxxxxxxx > >>>>>> To: Bastien Koert <bastien_k@xxxxxxxxxxx> > >>>>>> CC: php-db@xxxxxxxxxxxxx > >>>>>> Subject: RE: timestamp > >>>>>> Date: 31 Jan 2005 10:02:04 +0530 > >>>>>> > >>>>>> thanks > >>>>>> I tried strtotime also but getting 1970-01-01 not 2005-01-28. my > >>>>>> problem is that the date is given to me in string format i.e.Fri > >>>>>> Jan 28 > >>>>>> 19:53:09 2005. Any other help will be appreciated. > >>>>>> > >>>>>> with best wishes > >>>>>> balwant > >>>>>> > >>>>>> > >>>>>> On Sat, 2005-01-29 at 22:45, Bastien Koert wrote: > >>>>>> > >>>>>> > >>>>>>> try > >>>>>>> > >>>>>>> $date = date("Y-m-d",strtotime($timestamp)); > >>>>>>> > >>>>>>> Best thing to use if you want to do calcs on date/time data is > >>>>>>> to > >>>>>> > >>>> use > >>>> > >>>> > >>>>>> the > >>>>>> > >>>>>> > >>>>>>> unix time stamp...translates the timestamp into seconds since > >>>>>>> 01-01-1970...Much simpler to use in sql queries > >>>>>>> > >>>>>>> Bastien > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>> From: Balwant Singh <balwantsingh@xxxxxxxxxxxxx> > >>>>>>>> Reply-To: balwantsingh@xxxxxxxxxxxxx > >>>>>>>> To: php-db@xxxxxxxxxxxxx > >>>>>>>> Subject: timestamp > >>>>>>>> Date: 29 Jan 2005 19:47:35 +0530 > >>>>>>>> > >>>>>>>> i am facing a problem > >>>>>>>> > >>>>>>>> i have timestamp in string format --> Fri Jan 28 19:53:09 2005 > >>>>>>>> now > >>>>>>> > >>>> i > >>>> > >>>> > >>>>>>>> want to get the date from it. is it possible? pls. help. on using > >>>>>>>> strftime("%D",$timestamp) it is giving 01/01/70. May pls. help > >>>>>>>> me. > >>>>>>>> > >>>>>>>> Also pls. let me know whether calculation can be done in mysql > >>>>>>>> on > >>>>>>> > >>>> this > >>>> > >>>> > >>>>>>>> string timestamp. pls. inform. > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> with best wishes > >>>>>>>> balwant > >>>>>>>> > >>>>>>>> -- > >>>>>>>> PHP Database Mailing List (http://www.php.net/) > >>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php > >>>>>>>> > >>>>>>>> > >>>>>>> > >>>>>> -- > >>>>>> PHP Database Mailing List (http://www.php.net/) > >>>>>> To unsubscribe, visit: http://www.php.net/unsub.php > >>>>>> > >>>>>> > >>>>> > >>>> -- > >>>> PHP Database Mailing List (http://www.php.net/) > >>>> To unsubscribe, visit: http://www.php.net/unsub.php > >>>> > >>>> > >>> > >> > >> > >> > > > > -- > Experience is a good teacher, but she sends in terrific bills. > > Minna Antrim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php