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

    Join Date
    Nov 2003
    Posts
    5
    Rep Power
    0

    Angry help in a query plez!!


    this is driving me crazy...how do i get a ist of all the people who were born during 1975?

    my db looks like this:

    people_table

    first_name, last_name, dob, address

    dob is entered like: 14-jan-90
  2. #2
  3. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    308
    Rep Power
    11
    query would be like that:

    SELECT * from people_table
    WHERE to_char(dob,'YYYY')='1975'
    /

    Regards,
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    5
    Rep Power
    0
    thanx!

IMN logo majestic logo threadwatch logo seochat tools logo