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 |
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...
Which is better statement or preparedstatement?
What are the benefits of normalization?
what is a live lock? : Sql server database administration
How to use column default values in insert statements in ms sql server?
What is the STUFF function and how does it differ from the REPLACE function?
How to join two tables in a single query in ms sql server?
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
What is the contrast amongst drop and truncate?
Find first and last day of current month in sql server
What is the largest component inside a field?
What is a coalesce function?