Data converting in sqlite

SQLite_convert.sql

--convert `$150.00` to cents `15000` query sqlite> 
select replace(replace(Amount, '$', ''), '.', '') from test limit 5;

-- convert `$150.00` to cents `15000` in integer so we can `sum` query sqlite> 
select cast(replace(replace(Amount, '$', ''), '.', '') as integer) 
from test 
limit 5;

-- check column type sqlite> 
select typeof(created_at) 
from test 
limit 5;

-- text convert `03-02-2017` to `2017-02-03` query `sqlite> 
select created_at, date(substr(created_at,7,4)||'-'||substr(created_at,4,2)||'-'||substr(created_at,1,2)) 
from test 
limit 5;

-- export query output to file and exit
.once output.txt
.exit