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
- 13065 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepa
select getdate()
select Dateadd(dd,2,getdate())
select convert(varchar(12),Dateadd(dd,2,getdate()),106)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the name of the Database which IBM mainframe uses?
What method is used by the Command classes to execute SQL statements that return single values?
Write a sql query to display the current date?
How to filter records of table in SQL SERVER?
Explain primary key?
Explain isolation levels that sql server supports?
When would you use sql joins?
What is the rdl file?
what is a correlated sub-query? : Sql server database administration
How to receive output values from stored procedures?
What do you need to connect php to sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
When should you use an instead of trigger?
What are the differences between stored procedure and the dynamic sql?
What are Row versions of DataRow?
