exponential value to numeric in controller query

i have a table with column rate which is in exponential,needs to convert it in numeric. this is my sql query that runs fine in database SELECT CAST(1.6e+06 AS rate)

bobbybouwmann

8 years ago

Best Answer

Level 88

What is your exact question?

If you want to retrieve such a value using eloquent you can use a raw select or raw query

Documentation: https://laravel.com/docs/5.6/queries#raw-expressions

Please or to participate in this conversation.