SQL / PHP将字符串转换为float或int。

I have this sql query..

我有这个sql查询。

select i.invoiceid as transactionid, i.date, i.total, 
'invoice' as transaction_type
from invoice
select i