How to get number of days in a given year?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is self contained multi valued query?

550


Show Practically Sql Server Views are updatable?

586


Does view occupy space?

509


Explain indexed views?

555


What is meant by indexing files?

574






How can windows applications connect to sql servers via odbc?

577


What are the steps to process a single select statement?

505


Can we delete data from a view?

536


What is snapshot parameter in ssrs?

109


What are the built in functions in sql server?

484


What are the recovery models for a database?

611


Which tools are available to manage SQL Azure databases and servers?

93


What is the difference between insensitive and scroll cursor?

576


What are the advantages of passing name-value pairs as parameters?

655


Explain forward - only cursors?

513