Multiple choice technology

The following function can be used to trim the timestamp part from any DATE variable in Universe object

  1. ADD_DATE

  2. TRUNC

  3. SUBSTR

  4. TRIM
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNC function removes the time component from a DATE, returning midnight of that day (e.g., TRUNC(TO_DATE('2025-01-15 14:30:00')) = '2025-01-15 00:00:00'). TRIM operates on strings removing whitespace, not dates. SUBSTR extracts character portions from strings.

Keep practicing — related questions