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
- 12186 Views
- I also Faced
- E-Mail Answers
Answer Posted / shailesh s. deshmukh
select convert(varchar(20),getdate(),106)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Do you know the capabilities of cursors?
What are extended events in sql server?
What are exact numeric data types in ms sql server?
Do you know what is difference between index seek vs. Index scan?
What is subquery explain with example?
Do you know spatial data types - geometry and geography in sql server 2008?
What is scheduled job and how to create it?
What is the command used to recompile the stored procedure at run time?
What is @@rowcount in sql?
What is set nocount on?
What is query optimization process?
Disadvantages of the indexes?
How to provide values to stored procedure parameters in ms sql server?
What is analysis service repository?
