aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • SQL Error Codes and Database Concepts Quiz
  • to_date('2008','yyyy'); What is the output of this if sys...
Multiple choice technology databases

to_date('2008','yyyy'); What is the output of this if sysdate is 22-Sep-09

  1. 01-Jan-08

  2. 22-Sep-08

  3. 01-Sep-08

  4. None of above

Reveal answer Fill a bubble to check yourself
C Correct answer

Keep practicing — related questions

  • If sysdate is ‘17/10/2009’and we run the following query,what will be the Output?
  • What's the output select to_Date('2009-may-25','yyyymmdd') from dual
  • What's the output select to_Date('2009-may-25','yyyymmdd') from dual
  • let sysdate='19-SEP-2009' select round(sysdate,'YEAR'),round(sysdate,'MONTH') from dual would results in?
  • Identify the correct output --- select TRUNC(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'),'YEAR') from dual;
  • which one of the following is correct?
  • What is the output of DATE9. format?
  • Which of the following will produce the following output? '02 Nov 1997'
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy