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


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

Original text of this message