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 ...."??
Answer Posted / swapan
select convert(varchar(20),getdate()+int,100)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to list all objects in a given schema?
What is sql server programming?
Can you explain important index characteristics?
Explain the database you used in your final year project?
Different types of keys in SQL?
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain the functionalities that views support?
How to recreate an existing index in ms sql server?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
Where are sql server usernames and passwords stored in the sql server?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What are the authentication modes in sql server? How can it be changed?
explain databases and sql server databases architecture? : Sql server database administration
What is the full form of ddl?
Why I have to use stored procedures?