Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Why variables called the most powerful component of ssis?

1125


What is unpivot?

1074


What is it’s similarity with sql server?

160


Explain primary key in sql server?

1074


How many categories of data types used by sql server?

1055


what does the automatic recovery do? : Sql server administration

1081


What is merge replication?

1150


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

1170


When should you use an instead of trigger?

1024


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

938


How to download and install the scaled-down database adventureworkslt?

1039


How many ways to create table-valued functions?

1056


How is foreign key related to primary key?

1012


What are the kinds of subquery?

1071


How do you manipulate data?

949