select datediff(dd,'03-03-2008',getdate()) as dataDiff

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

Question Posted / jayesh l lolariya

Answer Posted / jayesh l lolariya

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can function return multiple values in sql?

988

Can a table have no primary key?

1010

how does a local variable is defined using t-sql? : Transact sql

950

What are sql commands?

938

What is input buffer in sql*plus?

1127

What is the difference between row level and statement level trigger?

960

How to execute a stored procedure?

1036

What is inner join in sql?

1004

Can ddl statements be used in pl/sql?

1069

what are myisam tables? : Sql dba

955

What is a temp table?

950

What do you mean by query optimization?

953

what is schema? : Sql dba

987

Can you do multiple joins in sql?

977

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003