Answer / sandhya

SELECT DATEDIFF(DD,HIREDATE,GETDATE())

Answer / koppalahareesh

declare @y int;
set @y = 2016;

SELECT DATEDIFF(day,cast(@y as char(4)), cast(@y+1 as char(4))) Days

Answer / dinesh rathod

would like to get the total number of days in a year left from the given

Answer / pulak

select add_months(trunc(sysdate,'year'),12)-trunc(sysdate,'year') as days from dual;

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

How are the exceptions handled in sql server programming?

0 Answers  

---

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

How can you check the version of sql server?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---