Interested to Buy Any Domain ? << Click Here >> for more details...
system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
- 8 Answers
- 14771 Views
- I also Faced
- E-Mail Answers
Answer Posted / bipin singh
Try this this will works fine.
select convert(varchar,dateadd(day,2,getdate()),106)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the basic features of a trigger in ms sql server?
List down some advantages of sql stored procedure?
What is co-related sub query?
Explain in brief how sql server enhances scalability of the database system?
Explain what are the restrictions while creating batches in sql server?
What are page splits? : SQL Server Architecture
Where the sql logs gets stored?
Where can you find the error log information? : sql server database administration
Explain having clause and where clause?
What is normalization and what are the advantages of it?
Is resultset an interface?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I get to sql server configuration manager?
In how many ways you can invoke ssrs reports?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
