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 #174736 is a reply to message #174731]

Thu, 30 June 2011 21:02

dougatmilmacdotcom
Messages: 24
Registered: May 2011

Karma:

Junior Member

In article <07dc80f0-d5cd-4390-a4f3-401de58d3b12(at)g9g2000yqb(dot)googlegroups(dot)com>, Co <vonclausowitz(at)gmail(dot)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?

Yes, there is.

When will you figure out that PHP groups are not appropriate places to ask SQL
questions?

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: Wed Nov 27 07:01:48 GMT 2024

Total time taken to generate the page: 0.04540 seconds