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
What are the tools available in market as an alternative to sql server reporting services?
What is a data source or ds? : sql server analysis services, ssas
Define the one-to-one relationship while designing tables.
explain different types of backups avaialabe in sql server? : Sql server database administration
How to include text values in sql statements?
What is implicit cursors?
How important do you consider cursors or while loops for a transactional database?
Explain data warehousing in sql server?
Explain datetime2 data type in sal server 2008?
What is measure group, measure? : sql server analysis services, ssas
What is the difference between ddl,dml and dcl commands?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How many instances per computer are there in sql server 2000?
Explain about Joins?