#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Evanston, IL 60202
    Posts
    10
    Rep Power
    0
    I have a date field (yyyy-mm-dd) that contains birthdays. I want to select everyone who has a birthday of mm-dd, regardless of the year they were born.

    Is there an easy way i can do this in my query?
    Select * from clients where birthdate = ????

    Thanks in advance,
    Mike
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    SELECT * FROM clients WHERE (MONTH(birthdate) = 5) AND (DAYOFMONTH(birthdate) = 14);

    Good Luck!
    yoshi
    datera@datera.com http://www.datera.com <-- Tour The Web

Similar Threads

  1. question about vb 6, query and excel
    By rt_hide in forum Visual Basic Programming
    Replies: 0
    Last Post: February 17th, 2004, 02:43 AM
  2. simple search query
    By SeenGee in forum PHP Development
    Replies: 1
    Last Post: February 10th, 2004, 12:30 PM
  3. (hopefully) simple SQL in java servlet question
    By djstyli in forum Java Help
    Replies: 3
    Last Post: February 5th, 2004, 07:58 PM
  4. Just a simple question!
    By Il Capitano in forum Perl Programming
    Replies: 1
    Last Post: January 23rd, 2004, 05:00 PM
  5. simple query help?
    By dwan in forum MS SQL Development
    Replies: 6
    Last Post: January 13th, 2004, 10:12 AM

IMN logo majestic logo threadwatch logo seochat tools logo