On Monday, May 18, 2015, er.tejaspate...@gmail.com <
er.tejaspate...@gmail.com> wrote:
> If I have to find upcoming birthdays in current week and the current week
> fall into different months - how would you handle that?
>
Extract(week from timestamptz_column)
ISO weeks are not affected by month
If I have to find upcoming birthdays in current week and the current week
fall into different months - how would you handle that?
--
View this message in context:
http://postgresql.nabble.com/Fastest-way-best-practice-to-calculate-next-birthdays-tp2068398p5849705.html
Sent from the PostgreSQL
