what about something like this?
$strdate = "Fri Jan 28 19:53:09 2005"; // place your date string here $newstr = substr_replace($strdate, '', 11, -5); // removes the time from your date string, bringing it inline with format required by strtotime() $tmstmp = strtotime($newstr); $date = date("Y-m-d",$tmstmp); Cheers, Dianne ----- Original Message ----- From: "Balwant Singh" <[EMAIL PROTECTED]> To: "Bastien Koert" <[EMAIL PROTECTED]> Cc: <firstname.lastname@example.org> Sent: Sunday, January 30, 2005 11:32 PM Subject: RE: [PHP-DB] timestamp > 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 <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: email@example.com > > >Subject: [PHP-DB] 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