RE: [PHP-DB] timestamp

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@indoasian.com> Reply-To: balwantsingh@indoasian.com To: Bastien Koert <bastien_k@hotmail.com> CC: php-db@lists.php.net Subject: RE: [PHP-DB] 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@indoasian.com> Reply-To: balwantsingh@indoasian.com To: php-db@lists.php.net 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