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

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

More SQL PLSQL Interview Questions

Is id a reserved word in sql?

Explain how can you save or place your msg in a table?

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

How can the performance of a trigger be improved?

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

how to find the second highest salary from emp table?

what are the non-standard sql commands supported by 'mysql'? : Sql dba

How exception handling is done in advance pl/sql?

When is the update_statistics command used?

Which are the different character-manipulation functions in sql?

For more SQL PLSQL Interview Questions Click Here