On Tuesday 08 August 2006 01:42 pm, James Mckenzie wrote:
> -----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.
Dates are stored as decimals using days. For example, 12.7500000
is 12 days and 18 hours.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
