-
Hi!
I want a query to list dates between two given dates.
Thank you!
-
Hi
Select , from
where
betweeen and
Vijay.s
-
Hi
Select col1,col2 from
tablename
where
datecol betweeen date1 and date2
Vijay.s
-
Plz give more details. Do you want to display all dates stored in your database and that are falling between given two dates ??? or just want to get dates between two dates (as in calender) ???
-
This query will give you the emp names who joined between
Mar 01 to Mar 31.
select emp_name from employee
where date_of_joined between '01-MAR-01' AND '31-MAR-01';
Hope it will work, If not give us some more details like
what table,column,critiria...etc. Good Luck
sree
-
If you want to list all the dates between two given dates (start_date and end_date) )then try the following:
SELECT start_date - 1 + ROWNUM
FROM all_objects
WHERE ROWNUM <= end_date - start_date;
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Hi!
I want to show dates between two given dates. This using "dual" table.
-
Why do you want to stick with dual? Dual has only one row, so it can return you only one date. You need a table or view that has at least so many rows as the dates you want to display. So what is wrong with the sollution with ALL_OBJECTS (or some similar publicly accesible view/table)? It is accesible to every user, the same way the DUAL.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
I want to list all the dates between two given dates (start_date and end_date)
where start_date = minimum date from a table
and end_date = sysdate
can u please guide for generating query for this
-
So you reply to an 8 yr old thread??
What have you tried?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|