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 ...."??
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
how you can get the list of largest tables in a database? : Sql server administration
What's new in sql management studio for sql server? : sql server management studio
whats new about truncate in sql server 2008?
What happens when converting big values to integers?
What are the disadvantages of using the stored procedures?
Explain various On-Delete options in a DB table. Which is the default option?
What is a constant or literal in ms sql server?
How would you add a section to a table?
What is the fastest way to permanently delete a 1 million row table named customers?
What is the difference between primary key and unique constraints?
What do you understand by a stored procedure?
Explain about remote stored procedure?
How to reaname table name without using sp_Rename in sql server..?
What is subquery explain with example?
Does table partitioning improve performance?