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 |
Which tcp/ip port does the sql server run on? How can it be changed?
Explain filestream storage of sql server 2008?
What is repeatable read?
Explain what is the purpose of sql profiler in sql server?
What is the difference between functions and stored procedures?
What are the differences between user defined functions and stored procedures?
What is meant by datasource?
What is mean by candidate key?
Can we add a cpu to sql server?
When is update_statistics command used?
when would you go for denormalization? : Sql server database administration
What is the advantage of sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)