Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.16 » View Incident Report |
Serious |
Reported By: Tomasz Mierzwinski Reported On: 12/7/2004 For: Version 4.15 Build 1 |
SELECT * FROM ANNIVERSARIES A WHERE (A.ALARM=TRUE AND A.ALARM_YEAR<:CURR_YEAR) AND ( ( EXTRACT(MONTH FROM A.ANNIVERS_DATE)=:CURR_MONTH AND ( (EXTRACT(MONTH FROM A.ANNIVERS_DATE)=A.ALARM_MONTH AND ALARM_DAY<=:CURR_DAY AND EXTRACT(DAY FROM A.ANNIVERS_DATE)>=:CURR_DAY) OR (EXTRACT(MONTH FROM A.ANNIVERS_DATE)<>A.ALARM_MONTH AND EXTRACT(DAY FROM A.ANNIVERS_DATE)>=:CURR_DAY) ) ) OR ( ALARM_MONTH=:CURR_MONTH AND EXTRACT(MONTH FROM A.ANNIVERS_DATE)<>:CURR_MONTH AND ALARM_DAY<=:CURR_DAY ) ) ORDER BY ANNIVERS_ID
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |