Re: MySQL datetime extraction
| From: | Yasir Malik | 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)
>