Date Query

------=_NextPart_000_0007_01C326BF.5F40D800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Friends


I have a Query regarding Displaying Dates=20

I have two field in my mysql Table for Date_from and Date_To

Retrived record was ' 04-08-2003 ' for Date_from
and ' 07-08-2003 ' for Date_To after using Date_Format function to =
change the default format from YYYY-mm-dd to
dd-mm-YYYY

I want to now display all the Dates between '04-08-2003' and =
'07-08-2003'

i.e 04-08-2003
05-08-2003
06-08-2003
07-08-2003
on my PHP form.

Can anybody help me in this regard?

Thanking You,

Prashant Akerkar



=20


------=_NextPart_000_0007_01C326BF.5F40D800--

Re: Date Query

Hello,

Prashant Akerkar wrote:
> Dear Friends

Please ask such kind of questions at genearal list at mysql@lists.mysql.com

This list is dedicated for BUG reports with repeatable test cases only.



> I want to now display all the Dates between '04-08-2003' and '07-08-2003'

SELECT ... WHERE Date_From BETWEEN '2003-08-04' AND '2003-08-07' ...

You can add Date_To condition too.




Best regards

--
I'm MySQL certified. Are you? -- http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org