How can I convert String to INT using LARAVEL SQL?

Question

How can I convert a String to an Int using Laravel SQL?

My SQL:

$playlistArr = ArtistPlaylist::where('artist_uuid', $this->artist_id)
      ->whereBetween('entry_date', [$previousMonthEndDate, $nowDate])
      ->selectRaw('sum(lastSubscriberCount) as lastSubscriberCountSum')
      ->selectRaw('entry_date')
      ->groupBy('entry_date')
      ->orderBy('entry_date')
      ->get();

I tried CAST, but it didn’t work:

$playlistArr = ArtistPlaylist::where('artist_uuid', $this->artist_id)
     ->whereBetween('entry_date', [$previousMonthEndDate, $nowDate])
     ->selectRaw('CAST(sum(lastSubscriberCount) as lastSubscriberCountSum) AS INT')
     ->selectRaw('entry_date')
     ->groupBy('entry_date')
     ->orderBy('entry_date')
     ->get()

Zia Yamin · Accepted Answer · 2021-02-09 08:18:48Z

2

You have a little mistake on your sql. you need to cast as int first before alias. change to below will work.

$playlistArr = ArtistPlaylist::where('artist_uuid', $this->artist_id)
      ->whereBetween('entry_date', [$previousMonthEndDate, $nowDate])
      ->selectRaw('CAST(sum(lastSubscriberCount) AS INT) as lastSubscriberCountSum')
      ->selectRaw('entry_date')
      ->groupBy('entry_date')
      ->orderBy('entry_date')
      ->get()

edited Feb 9, 2021 at 8:18

Zia Yamin

1,0262 gold badges13 silver badges39 bronze badges

answered Feb 9, 2021 at 8:03

Sok Hai

5464 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I convert String to INT using LARAVEL SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related