Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 2.12 » View Incident Report |
Serious |
Reported By: Bruce Vander Werf Reported On: 9/30/2001 For: Version 2.11 Build 1 |
SELECT M.FULLNAME, M.BIRTHDATE, EXTRACT(MONTH FROM M.BIRTHDATE) AS MM, EXTRACT(DAY FROM M.BIRTHDATE) AS DD FROM CAPeople M WHERE (M.BIRTHDATE IS NOT NULL) AND ((EXTRACT(MONTH FROM M.BIRTHDATE) > 9) OR ((EXTRACT(MONTH FROM M.BIRTHDATE) = 9) AND (EXTRACT(DAY FROM M.BIRTHDATE) > 1))) AND ((EXTRACT(MONTH FROM M.BIRTHDATE) < 10) OR ((EXTRACT(MONTH FROM M.BIRTHDATE) = 10) AND (EXTRACT(DAY FROM M.BIRTHDATE) < 31))) ORDER BY MM, DD
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 |