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
- 14429 Views
- I also Faced
- E-Mail Answers
Answer Posted / shailesh s. deshmukh
select convert(varchar(20),getdate(),106)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Is candidate a key?
How do clustered indexes store data?
What are the different normalization forms?
How to change a login name in ms sql server?
on line cluster can we make if yes tell me the procedure
What is a database in ms sql server?
What is 2nf normalization form?
What is normalization? Explain its different types?
How to drop an existing table?
What is the rdl file?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is join and name different type of joins?
What are unicode character string data types in ms sql server?
What are the differences between web role and worker role?
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
