How to display all Friday's in a year with date?
Answers were Sorted based on User's Feedback
Answer / dinesh
DECLARE
c date:='01-JAN-15';
d date:='31-DEC-15';
a number(10);
BEGIN
a:=d-c;
FOR i in 1..a
LOOP
IF to_char(c,'DY')='FRI' THEN
DBMS_OUTPUT.PUT_LINE('THIS IS FRIDAY DATE:='|| ' '|| c);
END IF;
c:=c+1;
END loop;
END;
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / dinesh
CREATE OR REPLACE PROCEDURE display_day_date(c date,d date,v varchar2) IS
a number(10);
m date:=c;
BEGIN
a:=d-m;
FOR i in 1..a
LOOP
IF to_char(m,'DY')= v THEN
DBMS_OUTPUT.PUT_LINE('THIS IS'||' '|| v ||' ' || 'DATE for the year '||' '||to_char(m,'yyyy')|| ' '|| m);
END IF;
m:=m+1;
END loop;
END;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nihar meher
declare
a date;
b date;
c number(15);
begin
select trunc(sysdate,'yyyy') into a from dual;
select add_months(trunc(sysdate,'yyyy'),12)-1 into b from dual;
c:=b-a;
for i in 1..c
loop
if to_char(a,'dy')='fri'
then
dbms_output.put_line(a);
end if;
a:=a+1;
end loop;
end;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kuldeep
select * from
(
SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL - 1) dt,
TRIM(TO_CHAR ((TRUNC (SYSDATE, 'yyyy') + LEVEL - 1), 'Day')) dy
FROM DUAL
CONNECT BY LEVEL <= 365
)
where dy='Friday'
Is This Answer Correct ? | 0 Yes | 0 No |
what is julian date in oracle
how to use in conditions? : Sql dba
How many levels can subqueries be nested in a FROM clause?
What is the basic difference between a sql and stored procedure ?
Can sql function call stored procedure?
what is the command line end user interface - mysql? : Sql dba
What is sqlservr exe?
Advantages and disadvantages of stored procedure?
What is sql*loader and what is it used for? : aql loader
What is sql stand for?
how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
explain mysql aggregate functions. : Sql dba