CURRENT_DATE vs NOW() for date filtering

Question

Accepted Answer

CURRENT_DATE gives you just the calendar date - no hours, minutes, or seconds. NOW() (or CURRENT_TIMESTAMP) gives the full timestamp including time zone. When you write WHERE created_at >= CURRENT_DATE, the date is implicitly cast to '2024-04-23 00:00:00', which is what you usually want for 'since the start of today'. Using NOW() - INTERVAL '7 days' works well too, but it compares to the current exact time 7 days ago rather than the start of that day - a subtle difference worth knowing.