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@xxxxxxxxxxxxx> Reply-To: balwantsingh@xxxxxxxxxxxxx To: Bastien Koert <bastien_k@xxxxxxxxxxx> CC: php-db@xxxxxxxxxxxxx Subject: RE: 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@xxxxxxxxxxxxx>
> >Reply-To: balwantsingh@xxxxxxxxxxxxx
> >To: php-db@xxxxxxxxxxxxx
> >Subject: 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
