Sign Up Login


  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 does rownum mean in sql?

0 Answers  

How do I run a sql query in pgadmin 4?

0 Answers  

What is spool?

0 Answers  

what is sql profiler

2 Answers   Fidelity,

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,




How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

what is try_catch block in procedure

0 Answers  

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

How to run sql functions in pl/sql?

0 Answers  

How do you sort in sql?

0 Answers  

How many sql are there?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories