$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


From: Balwant Singh <[EMAIL PROTECTED]>
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

PHP Database Mailing List (
To unsubscribe, visit:

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to