select convert(varchar(20),getdate(),106)

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
14050 Views
I also Faced
E-Mail Answers

Answer Posted / shailesh s. deshmukh

select convert(varchar(20),getdate(),106)

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is data source document?

980

How to apply filtering criteria at group level with the having clause in ms sql server?

947

What information is maintained within the msdb database?

928

what is the information that can be stored inside a bit column? : Sql server database administration

904

What is partitioned view?

855

How do I edit a stored procedure in sql server?

883

How to list all tables in the database using odbc_tables()?

983

What is the difference between row_number and dense_rank?

827

explain different levels of normalization? : Sql server database administration

932

Where do you find the default Index fill factor and how to change it?

1016

What is db stored procedure?

816

What are the system database in sql server 2005?

988

What is check constraint in sql server?

957

What are data regions?

121

Define outer join in sql server joins?

892