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

What are the steps to follow to configure SQL*Net?

1046

What is xml datatype?

1082

What is command parameter in ssrs?

164

How to enter comments in transact-sql statements?

951

Explain the properties of subqueries in sql server?

1085

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1068

Explain few of the new features of sql server 2008 management studio

923

Explain different types of lock modes in sql server 2000?

937

Can you explain what are various ways to enhance the ssrs report?

1004

What is database replication? What are the different types of replication you can set up in sql server?

964

What is clr ddl trigger?

978

What is the difference between DATETIME2 and DATETIME?

1085

How do you debug a procedure in sql server?

956

How do you delete a trigger?

987

Where are sql server usernames and passwords stored in the sql server?

1119