Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select Statement problem! Specify Month?
In article <8a422f$edi$1_at_nnrp1.deja.com>,
liam_2e_at_my-deja.com wrote:
> 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.
>
select *
from T
where to_char( birth_date, 'MM' ) = to_char(sysdate,'MM')
/
-- Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries http://osi.oracle.com/~tkyte/index.html -- Opinions are mine and do not necessarily reflect those of Oracle Corp Sent via Deja.com http://www.deja.com/ Before you buy.Received on Tue Mar 07 2000 - 00:00:00 CST
![]() |
![]() |