Re: Selecting Birthdays

From: VC <boston103_at_hotmail.com>
Date: Thu, 05 Feb 2004 02:13:38 GMT
Message-ID: <mFhUb.176935$sv6.934944@attbi_s52>

Hello Chris,

Select * from table1 where to_char(birthdate, 'mon')='apr' -- or 'may' or whatever

"Chris Hota" <cghota_at_uwm.edu> wrote in message news:d4b2092b.0402041658.49f2d577_at_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 - 20:13:38 CST