Ad

How Count The Hours Between Two Diferent Formats Using Laravel Query Builder?

I would like to count how many hours are between this two formats using laravel query builder.. how could I do that? I would like to know if it exists a way to transform my first format which is varchar into a Timestamp format.

enter image description here

enter image description here

Ad

Answer

Utilizing STR_TO_DATE function to parse your format, i got the following working in MySql.

->select(DB::raw("TIMESTAMPDIFF(HOUR, updated_at, STR_TO_DATE(fetch_tope, '%d/%m/%Y %h:%i:%s')) as hours"))
Ad
source: stackoverflow.com
Ad