three questions need queries

ramesh

Registered User.
Local time
Today, 17:58
Joined
May 18, 2002
Messages
25
there is a table in the database
the fields of which are as follows

empno number
name text
dob(date of birth) date/time
wedding_date date/time

i need to queries for the following questions..

1. given a dob as 05/08/2002 check whether this date is there or not in the dob column.(note i mean only 15th of august and not any other month)

2. given dates as 1/5/2002 and 31/5/2002 find out the list of dob falling in between these dates.


3. given a date as 15/5/2002 find out the wedding_date which are less than this date.

in all the above questions date mean for that particular month and year only.

help me out.

ramesh.s
 

Users who are viewing this thread

Back
Top Bottom