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

Thu, 30 June 2011 11:16

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 6/30/2011 4:21 AM, Co 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

Like I told you yesterday - this is not a PHP question. Try an
appropriate newsgroup, such as comp.databases.mysql.

Ask in the right place and you'll get a good answer.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

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 21:23:45 GMT 2024

Total time taken to generate the page: 0.05476 seconds