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
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
