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

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

Question Posted / guest

2 Answers
7959 Views
I also Faced
E-Mail Answers

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 native sql query?

0 Answers

what is innodb? : Sql dba

0 Answers

What is a delimiter in sas?

0 Answers

What is nvl?

0 Answers

Explain what is table in a database?

0 Answers

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers

How do you rename a table in sql?

0 Answers

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

0 Answers

what is log shipping? : Sql dba

0 Answers

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers Karrox,

What is the most restrictive isolation level? : Transact sql

0 Answers

What is the max nvarchar size?

0 Answers

For more SQL PLSQL Interview Questions Click Here