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

Home -> Community -> Usenet -> c.d.o.server -> Select Statement problem! Specify Month?

Select Statement problem! Specify Month?

From: <liam_2e_at_my-deja.com>
Date: 2000/03/07
Message-ID: <8a422f$edi$1@nnrp1.deja.com>#1/1

Hello Everyone
I am currently trying to write a query that I am having a hard time with maybe you can help. I am trying to write a query that shows everyone’s birthday for the current month. I am having a hard time specifying the month. This query should run on any month without modification. I believe that I will have to use the sysdate function and the last_day function but I am not sure how to put it together!

Thanks for the help
Liam

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 07 2000 - 00:00:00 CST

Original text of this message

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