sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format??
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 2 Yes | 1 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
How can change procedure in sql server?
Can you create a logon trigger in sql server 2005 express edition?
The Difference between 'Count' and 'Count(*)'
How to store and query spatial data?
What is normalization of database? What are its benefits?
explain how to create a new schema in a database? : Sql server database administration
How do you create type- insensitive operator?
How to Debug a Stored Procedure?
What is mscorsvw.exe - process - microsoft .net framework ngen?
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is a cube? : sql server analysis services, ssas