Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.php > #2411

Re: Get day and month part from date

From Jerry Stuckle <jstucklex@attglobal.net>
Newsgroups comp.lang.php
Subject Re: Get day and month part from date
Date 2011-06-30 07:16 -0400
Organization A noiseless patient Spider
Message-ID <iuhlul$9vm$2@dont-email.me> (permalink)
References <07dc80f0-d5cd-4390-a4f3-401de58d3b12@g9g2000yqb.googlegroups.com>

Show all headers | View raw


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@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Get day and month part from date Co <vonclausowitz@gmail.com> - 2011-06-30 01:21 -0700
  Re: Get day and month part from date Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-30 07:16 -0400
    Re: Get day and month part from date Bill B <me@privacy.net> - 2011-06-30 08:13 -0400
  Re: Get day and month part from date dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-30 21:02 +0000
  Re: Get day and month part from date Captain Paralytic <paul_lautman@yahoo.com> - 2011-07-01 03:29 -0700
    Re: Get day and month part from date Co <vonclausowitz@gmail.com> - 2011-07-03 08:20 -0700

csiph-web