Thanks. Here's how I did it: $str = "2003-12-13 12:23:34" $b = localtime(strtotime($str), 1); printf("seconds: ".$a["tm_sec"]."\n");
On Sat, 19 Jul 2003, John W. Holmes wrote: > Date: Sat, 19 Jul 2003 14:28:00 -0400 > From: John W. Holmes <[EMAIL PROTECTED]> > To: Yasir Malik <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] MySQL datetime extraction > > Yasir Malik wrote: > > Given a date in MySQL datetime format, how do I extract the elements? > > That is get the month, day, year, hour, ... > > You could do it in the query using DATE_FORMAT(), MONTH(), YEAR(), etc. > > You can do it in PHP by sending the MySQL timestamp through strtotime() > and then using date() to extract each component. > > -- > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > PHP|Architect: A magazine for PHP Professionals – www.phparch.com > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php