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

what stored procedure would you use to view lock information? : Sql server administration

967

Can you type more than one query in the query editor screen at the same time?

1005

How do you Implement SSIS Packages in your Project?

1920

How to backup encryption key ?

182

What is amo? : sql server analysis services, ssas

1086

How to provide values to stored procedure parameters in ms sql server?

1034

Does a full backup include transaction log?

962

What is the difference between varchar and nvarchar datatypes?

1080

What is query and its types?

909

Explain mixed authentication mode of sql server?

1052

What do you mean by sql server agent?

984

what is datawarehouse?

1103

What is sql server 2000 work load governor?

1055

what are the different types of replication you can set up in sql server? : Sql server database administration

1019

can an automatic recovery be initiated by a user? : Sql server administration

945