Re: Deleting by date.

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

The oracle seconds format is 'SS' which is a number from 00 to 59. What was your select statement that showed seconds to be 78911? Also please post your delete statement including the format mask so that we can be of better help to you.

Here is something that might help:

DELETE FROM foo
WHERE date_column > to_date('07/11/96 01:00:11','mm/dd/yy hh24:mi:ss');

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (preferred for work)
GPU Service Corporation                dsmoyer_at_enter.net (preferred for home)