select getdate() select Dateadd(dd,2,getdate()) select convert(varchar(12

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 ...."??

Question Posted / deepa

8 Answers
14320 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

Please Help Members By Posting Answers For Below Questions

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1190

Explain sql server service broker?

956

Is it important for a database administrator to understand the operating system and file access?

964

What is filtered index?

1076

Explain the first normal form(1nf)?

1004

What do you understand by integration services in sql server?

943

what are the Prerequisites for Replication?

11321

Explain error handling in ssis?

1001

What is clr ddl trigger?

936

What is built-in function?

978

What is the use of keyword with encryption. Create a store procedure with encryption?

944

What is ms sql server service broker?

967

What are the built in functions in sql server?

959

What is snapshot parameter in ssrs?

150

Explain the difference between cross join and full outer join?

964