Re: Deleting by date.
From: Steve Dodsworth] <Steven_Dodsworth_at_qsp.co.uk>
Date: 1996/07/09
Message-ID: <4rth2r$pqj_at_mailhost.qsp.co.uk>#1/1
Date: 1996/07/09
Message-ID: <4rth2r$pqj_at_mailhost.qsp.co.uk>#1/1
In <31D8A684.16D2_at_organic.com>, MAX <michael_at_organic.com> writes:
>If you have two records. One with a date in seconds of 78911
>and the second is 78940. How does one delete from the database.
>Tried
>
>delete where date(in seconds format) > 78939.
>two rows deleted
>
>delete where date(in seconds format) > to_date('78939',seconds format)
>two rows deleted.
>
>Whats the knowledge that I am missing.
>
>MIchael
Send in column defs and *exact* delete syntax
Bye,
Steve
| any similarity 'tween my opinions and that | | of my employers are purely hypothetical | | and should give no cause for alarm | --------------------------------------------Received on Tue Jul 09 1996 - 00:00:00 CEST