By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select
str_to_date('05-Dec-19 08.30.00.000000000', '%d-%b-%y %H.%i.%s.%f') date1,
str_to_date('05-Dec-19 08.31.00.000000000', '%d-%b-%y %H.%i.%s.%f') date2,
timestampdiff(
minute,
str_to_date('05-Dec-19 08.30.00.000000000', '%d-%b-%y %H.%i.%s.%f'),
str_to_date('05-Dec-19 08.31.00.000000000', '%d-%b-%y %H.%i.%s.%f')
)minutes_diff
| date1 | date2 | minutes_diff |
|---|---|---|
| 2019-12-05 08:30:00.000000 | 2019-12-05 08:31:00.000000 | 1 |