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 |
Does user triggers have entry for trigger with compilation errors?
What is time based sql injection?
Is sql harder than python?
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
what is sql.
How collections are improve the performance?
What is not null in sql?
Is sql port 1433 encrypted?
How do I create a memory optimized filegroup?
What is primary key secondary key alternate key candidate key?
Can we use views in stored procedure?
Is left join faster than join?