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
- 14803 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
Explain full-text indexing?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Explain Geography datatype in SQL Server
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is sql server programming?
How to list all user names in a database?
Show Practically Sql Server Views are updatable?
Explain about Normalization?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Explain partitioned view?
Why use stored procedures in sql server?
Explain how you can deploy an SSRS report?
What are the advantages of sql stored procedure?
