Cast a timestamp or interval to a string

SELECT the last day of month

Count the number of records per week