select * from ( SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL

How to display all Friday's in a year with date?

Question Posted / kuldeep

4 Answers
7597 Views
Flipkart, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why truncate is used in sql?

1003

How to call shell script from pl sql procedure?

1277

What are aggregate and scalar functions?

1017

What are the different types of database management systems?

999

how to increment dates by 1 in mysql? : Sql dba

976

What is Collation Sensitivity ? What are the various type ?

952

What are the 3 modes of parameter?

1154

what is the difference between clustered and non clustered index in sql? : Sql dba

1123

Whis is not false in primary key?

1454

what are the different functions in sorting an array? : Sql dba

1014

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1003

What is a constraint?

1020

How delete all data from all tables in sql?

944

Explain character-manipulation functions?

1125

What is record variable?

987