Re: Delete Data older than exactly 2 years

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: "Sanjay Mishra" <smishra_97@xxxxxxxxx>
  • Date: Fri, 20 Apr 2007 12:46:11 -0400

Sanjay

Can you tell me why you can't use the 365/366 logic but can use add_months ?

On 4/20/07, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:


Thanks Mindaugas

*Mindaugas Navickas <mnavickas@xxxxxxxxx>* wrote:

delete table  where record_timestamp < ADD_MONTHS(sysdate, -24)

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2007