Viewing profile — rainbowliquor

Actually I have an unpopular opinion in regards to your question on competency. The computing industry as a whole over the years has grown and morphed to the point that there’s a h…

True but in the use case of OPs example. In the article OP says "So if we wanted to find the count of users that signed up per week:" which "2017-06-05 00:00:00+00" isn't a week, i…

date_trunc() is one way but to_char is even better as you can get the resulting output to something nicer. Doing: SELECT DATE_TRUNC('week', CURRENT_TIMESTAMP); gives: 2017-06-05 00…