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
- 13066 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen kumar.dandu
select to_char('sysdate',dd mon yyyy)from dual
convert the date format to chars and retrive the the system
date in the format what eve r u like
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is cross join in sql server joins?
Can we create clustered index on composite key?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are the default system databases in sql server 2000?
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is auditing in sql server?
How to delete duplicate rows?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What are subquery and its properties?
What is the use of nvl work?
What are the new features are introduced in sql server 2012 reporting services?
What is dml command?
What extended events?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Can we use trigger new in before insert?
