🎴 Flashcard Mode
Ab Initio ETL Tool Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
The following function can be used to trim the timestamp part from any DATE variable in Universe object
AnswerClick to flip back
A
TRUNC
💡 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.