1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / bipin singh

Answer Posted / bipin singh

Try this this will works fine.

select convert(varchar,dateadd(day,2,getdate()),106)

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of local tables are there in sql server?

516

How do I find sql server instance name?

520

What is difference between unique and primary key?

487

What is tablix?

115

What are the types of joins in sql?

574




How do I find the sql server version?

537

What is executereader?

561

What is extent? Types of extents?

596

Explain the properties of the relational tables?

564

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

563

Explain the properties of sub-query in sql server?

521

What is difference between group by and having?

570

How to Sync Two SQL Azure Databases?

101

Can we install sql server 2016 on windows 7?

690

What is merge statement?

637