hi ml, currently we are trying to port a application from a sybase sql to maxdb (currently 7.5.00.24-3 as it is shipped with debian 3.1).
with sybase there is it possible to count nr of month's to a date, and the database takes care if it has 28, 30, 31 or even 29 day's. i was unable to find an appropriate query with maxdb, cause adddate on maxdb can only add day's. so the workaround was to multiply the month with 29 and check if it bigger than timestamp. this solution works only for sure, if the select is run at leasth before the 10th day of a month. does there exist better ideas with maxdb? greetings thomas -- # Thomas Stegbauer # https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x9A3F1866FC68E91D # Key fingerprint = 5A2D FEDC 8A50 F1BB 25FB 967B 9A3F 1866 FC68 E91D -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
