-----Original Message----- >From: Mc Fly <[EMAIL PROTECTED]> >Sent: Aug 7, 2006 10:02 PM >To: [email protected] >Subject: [users] using OOo Base > >Hello, >i´m using Openoffice since 2 weeks ist a realy good programm! >but now i´ve got a problem. >I have created a database with OOo Base and i want using SQL to delete old >data form the db > >DELETE FROM "Aufträge" WHERE "Liefertermin" < SYSDATE > >this command line works but i want to delete data where 14 days older than >the SYSDATE / NOW > >SYSDATE - 14 DAYS or SYSDATE - 14 DAY or SYSDATE - 14 > Try SYSDATE - (14*86400). I don't know if the system date is stored in seconds or days, but this might help.
James M. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
