Home » RDBMS Server » Server Administration » Using SQL - Can u print all the dates between two given dates
Using SQL - Can u print all the dates between two given dates [message #371162] Mon, 11 September 2000 07:41 Go to next message
sriram
Messages: 58
Registered: September 2000
Member
Hello Everybody,
It would be great help for me if anyone can solve the above query to display all the dates between 2 given dates. Please let me know at the earliest.

Thanks in Advance
Sriram
Re: Using SQL - Can u print all the dates between two given dates [message #371164 is a reply to message #371162] Mon, 11 September 2000 15:47 Go to previous messageGo to next message
Irving
Messages: 13
Registered: September 2000
Junior Member
Hi,

do you mean something like this:

spool c:\temp\dates.txt;
select mydate from mytable where mydate between 'date1' and 'date2' order by mydate;
spool off;

Regards =)
Re: Using SQL - Can u print all the dates between two given dates [message #371165 is a reply to message #371162] Mon, 11 September 2000 23:20 Go to previous messageGo to next message
sriram
Messages: 58
Registered: September 2000
Member
Hi Friend,
There is no use of any table.I have 2 dates say 12-Sep-2000 and 30-Sep-2000 . Using these two dates i have to print all the dates lying between these two. It is not stored in any table. I give it in the query itself.
Is that clear for u friend...
I want to get it in a single query...
With Regards
Sriram
Re: Using SQL - Can u print all the dates between two given dates [message #371169 is a reply to message #371162] Tue, 12 September 2000 10:10 Go to previous messageGo to next message
Lee
Messages: 56
Registered: May 1999
Member
Try this, let me know if this is what you want.

DECLARE
my_date DATE := SYSDATE;
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE (MY_DATE);
MY_DATE := MY_DATE + 1;
IF TO_DATE(my_date, 'DD-MON-YY') > '01-NOV-00' THEN
EXIT;
END IF;
END LOOP;
END;
Re: Using SQL - Can u print all the dates between two given dates [message #371170 is a reply to message #371162] Tue, 12 September 2000 10:38 Go to previous messageGo to next message
Irving
Messages: 13
Registered: September 2000
Junior Member
Hi again,

I think you can try something like this:

set serveroutput on
declare
date1 date:=sysdate;
date2 date:=sysdate + 10;
temp_date date;
begin
temp_date:=date1;
while temp_date < date2 + 1 loop
dbms_output.put_line (to_char(temp_date));
temp_date:=temp_date + 1;
end loop;
end;

Regards =)
Re: Using SQL - Can u print all the dates between two given dates [message #371182 is a reply to message #371162] Wed, 13 September 2000 07:03 Go to previous message
sriram
Messages: 58
Registered: September 2000
Member
No Guys I want do it in SQL alone not using PL/SQL.I want to know whether it can be done in SQL alone.
Previous Topic: Renaming columns
Next Topic: Re: Case sensitive
Goto Forum:
  


Current Time: Thu Mar 28 12:28:26 CDT 2024