FUDforum: comp.lang.php » Get day and month part from date

Home » Imported messages » comp.lang.php » Get day and month part from date

Show: Today's Messages :: Polls :: Message Navigator

Re: Get day and month part from date [message #174740 is a reply to message #174731]

Fri, 01 July 2011 10:29

Captain Paralytic
Messages: 204
Registered: September 2010

Karma:

Senior Member

On Jun 30, 9:21 am, Co <vonclausow...@gmail.com> wrote:
> Hi All,
>
> I would like to retrieve people's birthday from the database.
> But only those who celebrate the coming week.
>
> SELECT * FROM members WHERE birthday BETWEEN $today AND $today+7
>
> The birthday field holds also the year but I just need day and month.
> Is there a way to do this?
>
> Marco

It doesn't matter how many times you ask this question, it will still
remain a MySQL question and not a php one.

One general hint is that if you want to invent your own syntax, you
will need to build your own programming language. If you wish to use
the MySQL programming language then you must stick to the syntax as
published in its manual.

Report message to a moderator

[Message index]

		Get day and month part from date By: Co on Thu, 30 June 2011 08:21
		Re: Get day and month part from date By: Jerry Stuckle on Thu, 30 June 2011 11:16
		Re: Get day and month part from date By: me on Thu, 30 June 2011 12:13
		Re: Get day and month part from date By: dougatmilmacdotcom on Thu, 30 June 2011 21:02
		Re: Get day and month part from date By: Captain Paralytic on Fri, 01 July 2011 10:29
		Re: Get day and month part from date By: Co on Sun, 03 July 2011 15:20

Previous Topic:	barcode reader integration in web application
Next Topic:	show events in calendar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 00:36:47 GMT 2024

Total time taken to generate the page: 0.03207 seconds