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
- 12286 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepa
select getdate()
select Dateadd(dd,2,getdate())
select convert(varchar(12),Dateadd(dd,2,getdate()),106)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Name and describe few console utilities for ssrs?
Is there any difference between primary key and unique with the not null condition?
What are the dmvs? : sql server database administration
What is report subscription?
What do you understand by replication in sql server?
What happens when converting big values to integers?
Does index speed up select statements?
Can the query output be sorted by multiple columns in ms sql server?
Explain candidate key, alternate key, and composite key?
What is pessimistic concurrency?
How to enter date and time literals in ms sql server?
How to return the date part only from a sql server datetime datatype?
Can foreign key be duplicate?
What is collation?
Can we use max in where clause?
