Re: [GENERAL] Yearly date comparison?

2012-03-02 Thread Vincent Veyron
Le mardi 28 février 2012 à 20:14 -0800, Nick a écrit : What is the best way to find an event with a yearly occurrence? start_date DATE, end_date DATE, recurring TEXT ); Hi Nick, Your problem seems similar to that of managing subscriptions? If you can do anything about it,

Re: [GENERAL] Yearly date comparison?

2012-02-29 Thread Albe Laurenz
Nick wrote: What is the best way to find an event with a yearly occurrence? CREATE TABLE events ( start_date DATE, end_date DATE, recurring TEXT ); INSERT INTO events (start_date, end_date, recurring) VALUES ('2010-02-28','2010-03-01','yearly'); SELECT * FROM events WHERE

[GENERAL] Yearly date comparison?

2012-02-28 Thread Nick
What is the best way to find an event with a yearly occurrence? CREATE TABLE events ( start_date DATE, end_date DATE, recurring TEXT ); INSERT INTO events (start_date, end_date, recurring) VALUES ('2010-02-28','2010-03-01','yearly'); SELECT * FROM events WHERE (start_date+'2