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

Answer Posted / jayesh l lolariya

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

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

816


What do you mean by table in sql?

696


What is the need of a partition key?

728


What is delimiter sql?

702


how would you enter characters as hex numbers? : Sql dba

713






What is file based approach?

663


What is sqlcommand?

751


how to convert dates to character strings? : Sql dba

731


What is the difference between the conventional and direct path loads? : aql loader

902


Is sql sequential or random?

771


What is the purpose of my sql?

683


Is ms sql traffic encrypted?

681


What is range partitioning?

692


How do I partition a table in sql?

730


What is the difference between functions, procedures, and packages in pl/sql?

705