Re: [PHP] MySQL datetime extraction

[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,

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(

Re: [PHP] MySQL datetime extraction

TED] > 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 ex

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 li