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: 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
