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 / moid
select convert(varchar(20),getdate(),100)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to skip remaining statements in a loop block using continue statements?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Relational calculus is what type of language?
Can an entity have two primary keys?
Explain about SQLOS?
What are the approximate numeric data types?
What xml support does the sql server extend?
Explain mixed authentication mode of sql server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is SQL Azure Fabric?
Differentiate between truncate vs delete in mssql?
Differentiate between a having clause and a where clause.
Which Model uses the SET concept
How you can change the database name in SQL SERVER?
Can you explain powershell included in sql server 2008?