Sql problem
From: steinas <steinas_at_ifi.uio.no>
Date: 1995/05/31
Message-ID: <3qiffb$e9f_at_hasle.oslonett.no>#1/1
Date: 1995/05/31
Message-ID: <3qiffb$e9f_at_hasle.oslonett.no>#1/1
Hi!
I,m trying to assemble a sql sentence selecting students who have birth-
day between day x and day y and month between month x and month y independent
of year.
In vb this sentence works fine :
SELECT DISTINCT studreg.studno FROM studreg WHERE day(birthday)
BETWEEN 1 AND 15 AND month(birthday) BETWEEN 1 AND 5.
Can't find an easy way to translate this to Oracle. What do I have to do to get this sentence to work in Oracle?
Thanks in advance.
Steinar Received on Wed May 31 1995 - 00:00:00 CEST