DATE_DIFF( Dec 10 1997 5:55:10PM, NULL , 'DD' ) gives________
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- What is the output of DATE9. format?
- Answer the below query.. select to_date('01-01-51','DD-MM-YY') from dual ;
- For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp
- Assuming the date and time is 09/09/2009 09:09:09, what value will the following statement return SELECT TO...
- Which of the following will produce the following output? '02 Nov 1997'
- For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp
- If sysdate is ‘17/10/2009’and we run the following query,what will be the Output?
- The Date data type does not hold which type of information.