For eg; I have a values in column like 9, 30, sixty days, five months
I want to convert these sixty days to 60
and five months to 5
I have done this using case when for possible scenarios looking if there is any direct function I can make use of..
Thanks in Advance!!