Which function truncates date/time to a specified interval?

Which function truncates date/time to a specified interval?

• A. Date_Trunc
• B. Joins
• C. Cross Joins
• D. Full joins

Answer: (A)

Truncating date/time values to the start of a chosen interval is what this function does. The date_trunc function takes a unit like 'hour', 'day', or 'month' and a timestamp, returning the timestamp rounded down to the start of that interval. For example, date_trunc('hour', '2023-08-01 12:34:56') gives 2023-08-01 12:00:00. This is especially useful when you want to group time-series data into consistent buckets, such as hourly or daily groups, for aggregation. The other options describe different operations that combine rows from tables (joins) and do not modify the date/time value itself, so they don’t serve the purpose of truncating timestamps.

Truncating date/time values to the start of a chosen interval is what this function does. The date_trunc function takes a unit like 'hour', 'day', or 'month' and a timestamp, returning the timestamp rounded down to the start of that interval. For example, date_trunc('hour', '2023-08-01 12:34:56') gives 2023-08-01 12:00:00. This is especially useful when you want to group time-series data into consistent buckets, such as hourly or daily groups, for aggregation.

The other options describe different operations that combine rows from tables (joins) and do not modify the date/time value itself, so they don’t serve the purpose of truncating timestamps.