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
- 14428 Views
- I also Faced
- E-Mail Answers
Answer Posted / senthil kumar.m
select convert(varchar,getdate(),106)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is store procedure? When do you use?
Explain what is dbcc?
Explain Geography datatype in SQL Server
What does it mean to normalize data?
Can we use pragma autonomous_transaction in trigger?
What is difference between table aliases and column aliases? Do they affect performance?
What is use of except clause? How it differs from not in clause?
Write a query to find 5th highest amount paid from the customer table.
What is field with example?
What is difference between global temporary tables and local temporary tables?
What is standby servers? Explain types of standby servers.
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to generate random numbers with the rand() function in ms sql server?
What does man by sql wildcard characters in sql server?
What is difference between count (*) and count column?
