Postgresql query between date ranges
With dates (and times) many things become simpler if you use >= start AND < end. For example: SELECT user_id FROM user_logs WHERE login_date >= ‘2014-02-01’ AND login_date < ‘2014-03-01’ In this case you still need to calculate the start date of the month you need, but that should be straight forward in any number … Read more