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
14039 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

What encryption security is available in sql azure?

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1004

Who developed sql server?

875

In case you have filters in your report, when filters will be applied in cached report instance?

103

Would you store your query in a ssrs report or a database server? State the reason why?

148

What is global temp table?

948

What is deploy, process and build? : sql server analysis services, ssas

1034

What are some examples of schemas?

909

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

942

What is update_statistics command?

1018

How do you clear a log file?

983

What is the full form of ddl?

865

What are a scheduled jobs?

908

What are recommended options to be used while using db mirroring? : sql server database administration

1070

How to create a view on an existing table in ms sql server?

1052