Cast a timestamp or interval to a string
SELECT the last day of month
Count the number of records per week