Dear friend try this one select convert(varchar(11), getdate(),106)+(SEL

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 / shailesh s. deshmukh

8 Answers
14051 Views
I also Faced
E-Mail Answers

Answer Posted / shailesh s. deshmukh

Dear friend try this one

select convert(varchar(11), getdate(),106)+(SELECT right
(GETDATE(),8))
as Date

or

select convert(varchar(11), getdate(),106)+(SELECT STUFF
(getdate(), 1, 11, ''))
as Date

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How you provide security to cube? : sql server analysis services, ssas

924

What is transaction server distributed transaction?

978

Explain about sql server login?

1029

Why are views required in the sql server or in any other database?

910

What are the different types of data sources in ssrs?

188

What does sql server mean?

975

Name and describe few console utilities for ssrs?

276

What are the ways available in sql server to execute sql statements?

1041

What is the usage of sign function?

1040

Tell me what do we need queues in sql service broker?

927

Does sql server use t sql?

959

How would you add a section to a table?

970

What’s the use of custom fields in report?

892

What have included columns when we talk about sql server indexing?

991

Explain what is sql server english query?

988