Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
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