import mariadb

from mariadb.constants import CLIENT, FIELD_TYPE

import datetime

def timedelta_to_time(s):

    return (datetime.datetime.min + s).time()

conversions = {

    **{FIELD_TYPE.TIME: timedelta_to_time}

}

conn= mariadb.connect(db="test", converter=conversions)

cursor=conn.cursor()

cursor.execute("SELECT CAST(NOW() AS TIME)")

row= cursor.fetchone()

print(row)

del cursor, conn