SQLite query Unix timestamp

SELECT id, title, created_at, datetime(substr(created_at, 0, 11), ''unixepoch'') as ctime FROM "posts" WHERE status = ''draft'' ORDER BY id ASC LIMIT 0,100;