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 / bipin singh
Try this this will works fine.
select convert(varchar,dateadd(day,2,getdate()),106)
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Tell me what do we need queues in sql service broker?
What is the fastest way to permanently delete a 1 million row table named customers?
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
What is acid mean in sql server?
Can we return Data from 4(more than 1) tables in stored procedure?
Explain the phases a transaction has to undergo?
What happens to a trigger with multiple affected rows?
What are the tables in sql?
What are the advantages of stored procedure in sql server?
How to create user messages with print statements in ms sql server?
Explain the difference between cross join and full outer join?
Can two tables share the same primary key?
What is an identity?
Can one drop a column from a table?
Tell me the phases a transaction has to undergo?