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