Case else statement doesn't work
Could someone please take a look at this statement? The else clause doesn't insert the statement 'NOT FORMATTED' in the NEW DATE column when the statement is executed and discovers that this date 27Feb2008. I tried changing the apostrophe's etc but no luck. The pipe I am banging my head with is starting to hurt !!!
I am running oracle 11g on linux.
select date_time,
Case date_time
When date_time
Then regexp_substr(date_time,'(0?[1-9]|[1-2][0-2]/(0?[1-9]|[1-2][0-9] |3[0-1]/([[:digit:]](4)')
Else 'NOT FORMATTED'
End as "NEW DATE"
From temphone2
where date_time is not null;