Interested to Buy Any Domain ? << Click Here >> for more details...
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 ...."??
- 8 Answers
- 14441 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepa
select getdate()
select Dateadd(dd,2,getdate())
select convert(varchar(12),Dateadd(dd,2,getdate()),106)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to move database physical files in ms sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What programming language would you use to create embedded functions in ssrs?
What is table level trigger?
What is an example of a primary key?
How to connect to SQL Azure Database by using sqlcmd?
How to check table values in sql server?
What are the default system databases in sql server 2000?
What is the stuff?
How to Check if table exists in sql server?
What is implicit cursors?
Explain what are commit and rollback in sql?
How do you set a trace flag in sql server?
What are the Advantages of using CTE in sql server?
