Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Selecting Birthdays

Selecting Birthdays

From: Chris Hota <cghota_at_uwm.edu>
Date: 4 Feb 2004 16:58:00 -0800
Message-ID: <d4b2092b.0402041658.49f2d577@posting.google.com>


Hello-

I have a table:

tblPeople

	firstname	varchar2(50)
	lastname	varchar2(50)
	socialsec	varchar2(11)
	birthdate	date

I would like to select only the records that have birthdays in a specific month (ie, February). Is this possible? I am using Oracle 8i.

Thanks,

chris.

/ Chris Hota (cghota_at_uwm.edu)
| Small Application Programming Group Supervisor
| I&MT/Student Technology Services
| UW-Milwaukee
| Bolton 646 - (414)229-5401 (SAPG)

\ Cell Phone - (414)840-4682 Received on Wed Feb 04 2004 - 18:58:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US