Re: Sql problem
Date: 1995/06/01
Message-ID: <azmoodehD9I5nI.HE_at_netcom.com>#1/1
Ok, let's see
Can you use the following?
WHERE 1 < day(birthday) < 15
AND 5 < month(birthmonth) < 10
Is this what you are tying to do?
Just my 2 cents.
Mickey,
steinas (steinas_at_ifi.uio.no) wrote:
: 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 Thu Jun 01 1995 - 00:00:00 CEST