Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #2415
| From | dougatmilmacdotcom@example.com (Doug Miller) |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Get day and month part from date |
| Date | 2011-06-30 21:02 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <iuio98$q00$2@dont-email.me> (permalink) |
| References | <07dc80f0-d5cd-4390-a4f3-401de58d3b12@g9g2000yqb.googlegroups.com> |
In article <07dc80f0-d5cd-4390-a4f3-401de58d3b12@g9g2000yqb.googlegroups.com>, Co <vonclausowitz@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? Yes, there is. When will you figure out that PHP groups are not appropriate places to ask SQL questions?
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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