select convert(varchar(20),getdate()+int,100)

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 / swapan

8 Answers
14037 Views
I also Faced
E-Mail Answers

Answer Posted / swapan

select convert(varchar(20),getdate()+int,100)

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the tools available in market as an alternative to sql server reporting services?

119

What is a data source or ds? : sql server analysis services, ssas

948

Define the one-to-one relationship while designing tables.

856

explain different types of backups avaialabe in sql server? : Sql server database administration

919

How to include text values in sql statements?

983

What is implicit cursors?

1002

How important do you consider cursors or while loops for a transactional database?

908

Explain data warehousing in sql server?

988

Explain datetime2 data type in sal server 2008?

856

What is measure group, measure? : sql server analysis services, ssas

960

What is the difference between ddl,dml and dcl commands?

1056

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4296

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

983

How many instances per computer are there in sql server 2000?

1009

Explain about Joins?

935