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

Why primary key is required?

985

What does where 1/2 mean in sql?

1049

How many tables can you join in sql?

943

What is schema in sql?

929

What does pl sql stand for?

1097

What are the types of functions in sql?

997

What is a Mapplet?

1113

What are different joins used in sql?

1044

Explain autonomous transaction.

1148

What is primary key and foreign key with example?

917

how to check server status with 'mysqladmin'? : Sql dba

1054

What is query syntax?

955

What is sql table?

951

What do you mean by query optimization?

984

What is the limitation on the block size of pl/sql?

975