How to convert time format of 20090930 to 30-Sep-2009?

[srinathd]

I want to get the time in this format 2009-Sep-30 from 20090930

[richgalloway · Accepted solution]

This should work:

eval t=strftime(strptime(<your date field>, "%Y%m%d"), "%Y-%b-%d")