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

can we have a nested transaction? : Sql server database administration

1189

Write a SQL query to make a column as unique?

1078

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1057

What is the full form of dql?

1024

What is checkpoint in sql server?

1215

What is the meaning of resultset type_scroll_insensitive?

992

What is role playing dimension with two examples? : sql server analysis services, ssas

1052

What is use of except clause?

1140

What is create command?

1019

Name few endpoints exposed by ssrs 2012?

366

How to return the top 5 rows from a select query in ms sql server?

1209

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1246

Can we join two tables without primary key?

1093

What is an identity?

1076

What is correlated subquery in sql server?

1124