Use below instead (BigQuery Standard SQL)

TIME_DIFF(PARSE_TIME('%T', ciclos.hora_inicio), PARSE_TIME('%T', ciclos.hora_fin), MINUTE)    

note: assuming (per your comments) format of hora_inicio and hora_fin is like ’06:45:18′

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top