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

When you use @@error and try-catch?

1028

Explain about SQL server 2005?

957

How to delete existing triggers using "drop trigger"?

1036

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1175

Explain the concept of recursive stored procedure.

918

What is data modification?

943

What is rs.exe utility?

156

what are the core components of SSRS?

127

What types of replication are supported in sql server?

1048

What is data modeling and Reterminal integrity?

1943

Define right outer join?

963

How to create a user to access a database in ms sql server using "create user" statements?

937

What are parameterized reports? What are cascading parameters in ssrs reports?

156

What is a partition function in sql server?

1097

Is the primary key column of a table an index in ms sql server?

946