|
Provide a converter to convert values into another format, e.g. datetime.timedelta to datetime.time:
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
|
Instead of datetime.timedelta result will be datetime.time
|