select add_months(trunc(sysdate,'year'),12)-trunc(sysdate,'y

How to get number of days in a given year?

Question Posted / pulak

Answer Posted / pulak

select add_months(trunc(sysdate,'year'),12)-trunc(sysdate,'year') as days from dual;

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can you use order by when defining a view?

979

Explain about link server in sql server?

1062

Can group by be used without aggregate functions?

924

Which is the latest version of sql server and when it is released?

1114

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1116

Why truncate is ddl command?

1069

List out what other servers you can use with ssrs?

139

How you can get a list of all the table constraints in a database? : Sql server administration

1029

What is the New in SQL server 2008?

978

Explain cursor as data base object?

1043

Is it possible to create trigger on views?

993

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

973

Explain about thread and memory management process of SQL?

975

Explain an automatic checkpoint

977

What are the different types of replication you can set up in sql server?

1052