Thomas Stegbauer wrote: > > 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? >
The only idea I have is to use Oracle-mode, timestamp and function add_months. Elke SAP Labs Berlin > greetings > thomas > > > > -- > # Thomas Stegbauer > # > https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x9A3F1 866FC68E91D > # 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] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
