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
- 13069 Views
- I also Faced
- E-Mail Answers
Answer Posted / moid
select convert(varchar(20),getdate(),100)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the difference between primary keys and foreign keys?
Explain active/passive and active/active cluster configurations?
What is difference between join and natural join?
Explain syntax for viewing, dropping and disabling triggers?
What are the requirements on sql server network connections?
How do I delete a sql server database?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
your distribution database is full what will u do
What are date and time data types in ms sql server?
What are the types of subquery?
What is the ‘fillfactor’?
Where cross join is used?
How does stuff differ from the replace function?
How to delete existing triggers using "drop trigger"?
Where in ms sql server is ’100’ equal to ‘0’?
