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
- 13076 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 is executereader?
Why the trigger fires multiple times in single login?
What is raid? : SQL Server Architecture
What are the different types of stored procedures?
Define synonym?
What is the function of sql server agent windows service?
Explain contrast amongst grouped and non-bunched records?
what is the sql equivaent of the dataset relation object ?
What stored by the model?
What is the cartesian product of table?
How to create function with parameter in sql server?
How to use “drop” keyword in sql server and give an example?
how you can get the list of largest tables in a database? : Sql server administration
what are the reporting service components in SSRS?
What is the difference between migration and upgradation in sql server?
