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...


write a query to display diference between two dates in sql
server

Answers were Sorted based on User's Feedback



write a query to display diference between two dates in sql server..

Answer / pushpa

datediff(mm,getdate(),'9/6/1980')

Is This Answer Correct ?    9 Yes 4 No

write a query to display diference between two dates in sql server..

Answer / jayesh l lolariya

select datediff(dd,'03-03-2008',getdate()) as dataDiff

Is This Answer Correct ?    7 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,


What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  


what is table? : Sql dba

0 Answers  


What is difference between cursor and ref cursor?

1 Answers  


What is the difference among union, minus and intersect?

0 Answers  


How can I delete duplicate rows?

0 Answers  


Explain what is an index?

0 Answers  


What is rule base and cost base optimizer?

2 Answers   Thermotech,


how to get second highest salary in SQL(as/4000

29 Answers   iGate,


What is pl sql variable?

0 Answers  


Explain constraints in sql?

0 Answers  


Does access use sql?

0 Answers  


Categories