1. What does the function DATE_TRUNC('month', TIMESTAMP '2023-08-15 14:30:00') evaluate to?
- 8
- 'August'
- 2023-08-01 00:00:00
- 2023-08-15 00:00:00
Hint: DATE_TRUNC sets all fields less significant than the specified unit (in this case, 'month') to their minimum value (day 1, time 00:00:00).