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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

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

What is composite data type in pl sql?

0 Answers  

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

What is compute?

0 Answers  

Can we use ddl statements in stored procedure?

0 Answers  

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  

What is auto increment feature in sql?

0 Answers  

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

What is left join example?

0 Answers  

What is the purpose of the primary key?

0 Answers  

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

Is sql a backend?

0 Answers  

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories