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
- 14770 Views
- I also Faced
- E-Mail Answers
Answer Posted / senthil kumar.m
select convert(varchar,getdate(),106)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is create database syntax? : Sql server database administration
What is ssrs?
What is SQL Azure Firewall?
Differentiate between delete and truncate.
What are the Advantages of using CTE in sql server?
What is service broker?
Difference between aggregate functions of sql?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What do you mean by an execution plan? How would you view it?
Does sql server use t sql?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain Reporting Life Cycle?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Explain acid?
