SELECT
    CAST(weather.date AS date)
FROM
    weather
RIGHT JOIN transactions ON
    CAST(weather.date AS date) = CAST(transactions.date AS date)
WHERE
    transactions.date IS NULL;