5.3.9.2 Calcul du délai de prescription
SELECT categories.* FROM (SELECT DISTINCT CAST(SUBSTRING(members.anchor, 10) AS UNSIGNED) AS target FROM yacs_members AS members WHERE (members.member LIKE 'article:6598') AND (members.anchor LIKE 'category:%')) AS ids, yacs_categories AS categories WHERE (categories.id = ids.target) AND (categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2024-12-27 20:15:38')) ORDER BY rank, title, edit_date DESC LIMIT 0,40
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,40' at line 1
SELECT sections.* FROM yacs_sections AS sections WHERE (sections.anchor='' OR sections.anchor IS NULL) AND (sections.active='Y') AND (sections.index_map = 'Y') AND ((sections.activation_date is NULL) OR (sections.activation_date <= '2024-12-27 20:15:38')) AND ((sections.expiry_date is NULL) OR (sections.expiry_date <= '0000-00-00 00:00:00') OR (sections.expiry_date > '2024-12-27 20:15:38')) ORDER BY rank, title, edit_date DESC LIMIT 0,8
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', title, edit_date DESC LIMIT 0,8' at line 1
Le délai de prescription se calcule en jours. L’heure à laquelle s’est produit l’événement donnant droit à une indemnité n’est pas considérée.
Le jour où s’est produit l’événement ne doit pas être calculé dans la computation du délai. Par contre, le dernier jour doit être calculé.
Si la date d’échéance expire un jour où les bureaux de la Société ne sont pas ouverts, le délai est prolongé jusqu’au premier jour ouvrable suivant