The following code outputs a SQLite date into a standard date format with month abbreviations that, believe it or not, Flex/AIR will accept as a Date value (Though SQLite itself doesn’t recognize it as a valid DATETIME!). I created this atrocious code while trying to figure out the mysterious interaction between AIR and SQLite date values. Julian time format is what you should use, though, for AIR applications. I decided to post this code up just for curiosity sake and future reference:
SELECT
CASE WHEN ( strftime('%m',my_column) = '01') THEN ('Jan') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '02') THEN ('Feb') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '03') THEN ('Mar') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '04') THEN ('Apr') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '05') THEN ('May') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '06') THEN ('Jun') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '07') THEN ('Jul') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '08') THEN ('Aug') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '09') THEN ('Sep') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '10') THEN ('Oct') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '11') THEN ('Nov') ELSE '' END
|| CASE WHEN ( strftime('%m',my_column) = '12') THEN ('Dec') ELSE '' END
|| STRFTIME(' %d %H:%M:%S GMT-0600 %Y', my_column)
FROM my_table