Which function creates a date or time value from components?

Which function creates a date or time value from components?

• A. NOW
• B. Date_Trunc
• C. make_date/time
• D. Joins

Answer: (C)

Constructing a date or time value from components requires a constructor that takes the individual parts (year, month, day for a date; hour, minute, second for a time) and returns the corresponding value. The function that does this is make_date or make_time (often shown together as make_date/time). For example, make_date(2024, 7, 9) yields a date, and make_time(14, 30, 0) yields a time. The other options don’t build from components: NOW gives the current moment, Date_Trunc rounds an existing timestamp to a specified precision, and Joins is used to combine rows from tables rather than to create a date or time value.

Constructing a date or time value from components requires a constructor that takes the individual parts (year, month, day for a date; hour, minute, second for a time) and returns the corresponding value. The function that does this is make_date or make_time (often shown together as make_date/time). For example, make_date(2024, 7, 9) yields a date, and make_time(14, 30, 0) yields a time. The other options don’t build from components: NOW gives the current moment, Date_Trunc rounds an existing timestamp to a specified precision, and Joins is used to combine rows from tables rather than to create a date or time value.