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

Get day and month part from date [message #174731]

Thu, 30 June 2011 08:21

Co
Messages: 75
Registered: May 2011

Karma:

Member

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

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: Sat Nov 23 15:20:54 GMT 2024

Total time taken to generate the page: 0.04031 seconds