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

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

Question Posted / pushpa

Answer Posted / pushpa

Is This Answer Correct ?

9 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the types of optimization?

889

What types of commands can be executed in sql*plus?

1051

Which sql statement is used to return only different values?

954

Is oracel sql developer written in java?

1060

What is Difference Between Unique and Primary Key Constraints?

1060

how to create a table index in mysql? : Sql dba

988

what are the performance and scalability characteristics of mysql? : Sql dba

944

What is difference between nchar and nvarchar?

958

What is the mutating table and constraining table?

969

Why do we use subquery?

944

Can sql developer connect to db2?

989

How much does sql cost?

931

What is the difference between a primary key and a clustered index?

934

What is assignment operator in pl sql?

970

What is an inconsistent dependency?

981