Multiple choice technology databases

which one of the following is correct?

  1. to_char(sysdate,'mm/yy')

  2. to_char('sysdate','mm/yy')

  3. to_char(sysdate,mm/yy)

  4. All the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

TO_CHAR converts a date to a string with the specified format. Option A correctly passes the unquoted sysdate function and quoted format string. Option B incorrectly quotes 'sysdate' as a literal string, and Option C fails to quote the format string.

Keep practicing — related questions