system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

What are the properties of the transaction?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

---

Which virtual table does a trigger use?

3 Answers  

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

1 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---

What is cursor in ms sql server?

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---

Wht is Stuff in sql ser

2 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---