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: php-db@lists.php.net
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: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php