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

How do I delete a trigger?

1012

what's the difference between a primary key and a unique key? : Sql dba

1104

What is form and report?

1048

What is sql profiling in oracle?

1126

Is oracel sql developer written in java?

1161

what is the difference between delete and truncate statement in sql? : Sql dba

1341

What is user defined functions?

1024

What is a left inner join?

1068

What do you mean by query optimization?

1044

what is index? : Sql dba

1039

what is “go” in t-sql? : Transact sql

1153

What is recursive stored procedure?

1139

what is cross join? : Sql dba

1044

What is difference between table and view?

1129

Which is faster joins or subqueries?

1032