Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 2 Answers
- 5812 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you make a trace?
How to generate random numbers with the rand() function in ms sql server?
Explain what is “asynchronous” communication in sql server service broker?
What is the use of custom fields in report?
What is difference between createstatement and preparedstatement?
what are candidate key, alternate key and composite key? : Sql server database administration
What are the different ways you can create databases in sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How to view existing indexes on an given table using sp_help?
What is isnull() operator?
How to use "begin ... End" statement structures in ms sql server?
How to list all user defined functions in the current database?
List out some of the requirements to set up a sql server failover cluster?
Can I disable or restrict ssrs export formats (rendering formats)?
What is tempdb in sql server?
