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
- 12187 Views
- I also Faced
- E-Mail Answers
Answer Posted / shailesh s. deshmukh
Dear friend try this one
select convert(varchar(11), getdate(),106)+(SELECT right
(GETDATE(),8))
as Date
or
select convert(varchar(11), getdate(),106)+(SELECT STUFF
(getdate(), 1, 11, ''))
as Date
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are different types of views?
How to set database to be single_user in ms sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is the difference between update lock and exclusive lock?
How to find the service pack installed? : sql server database administration
What is the query and subquery?
Are all views updatable ?
What does nvl stand for?
What stored by the model? : sql server database administration
How to generate create procedure script on an existing stored procedure?
How to transfer data from a cursor to variables with a "fetch" statement?
What are the different types of join?
how you can get the list of largest tables in a database? : Sql server administration
How do you set a trace flag in sql server?
What is the impact on other user sessions when creating indexes?
