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
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