Re: MySQL datetime extraction

From: Date: Sat, 19 Jul 2003 18:26:07 +0000
Subject: Re: MySQL datetime extraction
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-155906@lists.php.net to get a copy of this message
What list do I go to? I just want store the elements into some variables in PHP. Yasir On Sat, 19 Jul 2003, David Nicholson wrote: > Date: Sat, 19 Jul 2003 19:22:25 +0100 > From: David Nicholson <me@djnicholson.com> > To: Yasir Malik <ymalik@cs.stevens-tech.edu> > Cc: php-general@lists.php.net > Subject: Re: [PHP] MySQL datetime extraction > > Hello, > > This is a reply to an e-mail that you wrote on Sat, 19 Jul 2003 at > 19:16, lines prefixed by '>' were originally written by you. > > > Given a date in MySQL datetime format, how do I extract the > elements? > > That is get the month, day, year, hour, ... > > Thanks, > > Yasir > > Bit off topic for this list, but see the DATE_FORMAT() function at > http://www.mysql.com/doc/en/Date_and_time_functions.html > > David. > > -- > phpmachine :: The quick and easy to use service providing you with > professionally developed PHP scripts :: > http://www.phpmachine.com/ > > Professional Web Development by David Nicholson > http://www.djnicholson.com/ > > QuizSender.com - How well do your friends actually know you? > http://www.quizsender.com/ > (developed entirely in PHP) >

« previous php.general (#155906) next »