Results 1 to 2 of 2
  1. #1
    orchid's Avatar
    orchid is offline Member
    Join Date
    Apr 2007
    Location
    Midwest
    Posts
    60
    Rep Power
    0

    Default oracle query with date question

    How would I get a ist of all the people who were born during any particular year from my db?

    Here is my table :

    people_table

    first_name, last_name, dob, address

    dob is entered like: 14-jan-90

    thx

  2. #2
    sandor is offline Member
    Join Date
    Apr 2007
    Location
    Pennsylvania,USA
    Posts
    45
    Rep Power
    0

    Default

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

Similar Threads

  1. Getting current date using dual (Oracle)
    By Java Tip in forum Java Tip
    Replies: 1
    Last Post: 02-13-2008, 05:46 PM
  2. Please Help - Java Date/Countdown Query
    By desktop_doodle in forum New To Java
    Replies: 2
    Last Post: 01-08-2008, 05:53 PM
  3. Replies: 1
    Last Post: 07-24-2007, 01:15 AM
  4. in an oracle query
    By bbq in forum JDBC
    Replies: 2
    Last Post: 07-04-2007, 08:53 AM
  5. oracle question
    By sandor in forum JDBC
    Replies: 1
    Last Post: 05-01-2007, 11:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •