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
- 13068 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapan
select convert(varchar(20),getdate()+int,100)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How many triggers you can have on a table?
What is tablix?
What is the difference between createstatement and preparedstatement?
What is the datatype of rowid?
What are .mdf files?
What is 1nf normalization form?
How to execute multiple stored procedures at one time in sql server?
What is SQL Azure Data sync?
How to check if stored procedure is running in sql server?
Explain atomicity?
What is a periodical index?
How to truncate the log in sql server 2012? : sql server database administration
How connect excel to sql server?
Explain the third normal form(3nf)?
How to create an inline table-valued function?
