Results 1 to 2 of 2
  1. 05-09-2007, 12:09 AM #1
    orchid's Avatar
    orchid
    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
    Reply With Quote Reply With Quote
  2. 05-09-2007, 12:10 AM #2
    sandor
    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'
    Reply With Quote Reply With Quote
« Hibernate table not found | threads and hibernate »

Similar Threads

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

Bookmarks

Posting Permissions

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

Forum Rules