Answer / ritesh parkhi

Yes you can convert it through using
"select
convert(varchar(20),strDate,[1,2,3,4,5,6,101,102,103,104,105,106])"

diffrent diffrent code is present here you can try to use
all like
"select convert(varchar(20),strDate,101)"
where strDate is your date like "12/05/2008" or date from
database.Try it it will solve your problem.

Now second problem to get privious and cming date
"select dateadd(dd,2,strDate)"
i used here dateadd function where dd is used for Day.you
can use MM for month and YYYY fro year also.After that I
gave 2,it is the number to increment in days ,month and
year.and in last i gave strDate

Now i want to get date before 2 days so i will right
"select dateadd(dd,-2,strdate)"

Hopw you will get your answers

Answer / rohit agarwal

hello mr. ritesh u got write queary but there should be one
modification in place of strdate it will be getdate()
funtion like this:

select datedd(dd,-2,getdate())

from this queary u will get date before 2 days due to -2
ok
so swapan try this query u will get ur answer

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

How can I create a new template for import ? : sql server management studio

0 Answers  

---

How to enable tcp/ip protocol on a sql server?

0 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

What is the difference between local and global temporary tables?

0 Answers  

---

What is recompile sql server?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

From where can you change the default port?

3 Answers  

---