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
- 12190 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 bcp? When does it use?
How can you know if the row fetched from cursor is still valid in underlying table?
What is table-valued sub query?
What is user defined datatypes and when you should go for them?
How do I run sql server 2014?
What is the primary use of the model database?
What is tablesample?
What is mean by candidate key?
What is relationship? What number of sorts of relationship are there?
What is dbcc command in sql server?
What is compression - row-level and page-level compression?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Why do we need normalization?
What do we need queues in sql service broker?
What is parameterized reports in ssrs ?
