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" <balwantsingh@xxxxxxxxxxxxx>
To: "Bastien Koert" <bastien_k@xxxxxxxxxxx>
Cc: <php-db@xxxxxxxxxxxxx>
Sent: Sunday, January 30, 2005 11:32 PM
Subject: RE: 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 <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
