SQLite Forum

Convert datetime string to second since Epoch with millisecond precision
Login
Convert to julianday, which is floating point, correct the offset (origin date) and then correct the slope (unit scale) ...

select (strftime('%J', '2016-06-13T09:36:34.123Z') - 2440587.5) * 86400.0;  
1465810594.123

or

select (julianday('2016-06-13T09:36:34.123Z') - 2440587.5) * 86400.0;  
1465810594.123

The number 2440587.5 is the epoch adjustment to the unix epoch date:  

sqlite> select julianday('1970-01-01 00:00:00.000Z');  
2440587.5