Re: Selecting Birthdays

Chris Hota wrote:

> 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

Of course it is. Where were you when your instructor was talking about the TO_CHAR function? ;-)

You will find what you need at:
http://www.psoug.org/reference/date_func.html

Just test the various formats until you find the ones that will do what you want.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)