Database Administration (MOSC)

MOSC Banner

want to delete the old data

edited Dec 28, 2009 2:16PM in Database Administration (MOSC) 14 commentsAnswered
Dear All,
 In a table I have a column having data type varchar2.Date is stored in that column in the format
2008-10-30T14:48:10
2008-10-30T14:48:10

Now ,I want to delete data 100 days old based on this column.

How I can do this??

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center