CODEWITHSUNDEEP
sqloracle-database
john
john

Reputation: 145

Deleting records based on run date in Oracle

I am able to delete the data in a table for a particular run date and I am not able to delete the data for another run date.

Ex: I am able to delete data on 22-nov-2017 run date but not able to delete for 21-nov-2017

here is the query i am using 

DELETE FROM country WHERE trunc(RUN_DATE) = '21-NOV-17'

Upvotes: 0

Views: 3922

Answers (1)

Thangamani Eraniyan
Thangamani Eraniyan

Reputation: 83

I think you are getting a date format error.

Maybe this would work better:

DELETE FROM country WHERE trunc(RUN_DATE) = To_date('21-NOV-17','DD-MON-YY')

Upvotes: 2

Related Questions