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

Explain boyce and codd normal form(bcnf)?

1016

How to stop log file growing too big?

1064

How to return the date part only from a sql server datetime datatype?

1168

What are click through reports?

149

When you use @@error and try-catch?

1098

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1122

Name 3 ways to get an accurate count of the number of records in a table?

1088

What is difference between drop truncate and delete?

1157

How adventureworkslt tables are related?

984

What is compression - row-level and page-level compression?

965

write an SQL query to list the employees who joined in the month of January?

1741

What is user-defined multi-statement table-valued function?

1120

What is nolock hint in sql server 2008

1184

What type of Index will get created after executing the above statement?

1146

How to create “dependant” parameter “make, model, year”

137