What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
Answers were Sorted based on User's Feedback
Answer / welcomeashwin
ORA-00909 invalid number of arguments
Cause: An Oracle function was referenced with an incorrect
number of arguments. All Oracle functions, except for
SYSDATE, require at least one argument.
Action: Correct the syntax of the function by entering the
required number of arguments.
Is This Answer Correct ? | 33 Yes | 3 No |
Answer / nitin
Let SYSDATE = '20-Sep-2012'
Use below query,
select to_char(trunc(add_months(sysdate,-
3),'mm'),'mm/dd/yyyy') from dual;
It will give you ...
o/p :
'06/01/2012'
Is This Answer Correct ? | 15 Yes | 9 No |
Answer / praveen
Let sysdate=30/07/2012;
let see dis query
select add_months(sysdate,-3) from dual;
//ans=07/30/2012-mm/dd/yyyy
select trunc(add_months(sysdate,-3),'mm') from dual;
//ans=07/01/2012-mm/dd/yyyy
select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyyy from dual;
//ans=07/01/2012-mm/dd/yyyy
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sreeharibabu
select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyyy') from dual;--sysdate:22-APR-2016 output :01/01/2016
-- corrections in add_months , mm ,mm/dd/yyyy
--- flow--
select add_months(sysdate,-3) from dual;--sysdate:22-APR-2016 -- output : 1/22/2016 8:15:24 AM
select trunc(add_months(sysdate,-3),'mm') from dual;--sysdate:22-APR-2016 output : 01/01/2016
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajeev
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual--This query will return error...
we can use below query..
select to_char(trunc(add_months(sysdate-1,3),'mm'),'mm/dd/yyyy') from dual;
output:05/01/2018
Is This Answer Correct ? | 0 Yes | 0 No |
what is text? : Sql dba
Can we write create command in the plsql block?if possible how?
what are the nonstandard string types? : Sql dba
Which is better trigger or stored procedure?
Does asenumerable execute the query?
What is #table in sql?
What are different sql data types?
what are sequences
What is compound trigger?
Are stored procedures faster than dynamic sql?
Give the structure of the function ?
What are the operators used in select statements?