MCPcopy Create free account
hub / github.com/PyMySQL/PyMySQL / convert_datetime

Function convert_datetime

pymysql/converters.py:166–193  ·  view source on GitHub ↗

Returns a DATETIME or TIMESTAMP column value as a datetime object: >>> convert_datetime('2007-02-25 23:06:20') datetime.datetime(2007, 2, 25, 23, 6, 20) >>> convert_datetime('2007-02-25T23:06:20') datetime.datetime(2007, 2, 25, 23, 6, 20) Illegal values are returned as

(obj)

Source from the content-addressed store, hash-verified

164
165
166def convert_datetime(obj):
167 """Returns a DATETIME or TIMESTAMP column value as a datetime object:
168
169 >>> convert_datetime('2007-02-25 23:06:20')
170 datetime.datetime(2007, 2, 25, 23, 6, 20)
171 >>> convert_datetime('2007-02-25T23:06:20')
172 datetime.datetime(2007, 2, 25, 23, 6, 20)
173
174 Illegal values are returned as str:
175
176 >>> convert_datetime('2007-02-31T23:06:20')
177 '2007-02-31T23:06:20'
178 >>> convert_datetime('0000-00-00 00:00:00')
179 '0000-00-00 00:00:00'
180 """
181 if isinstance(obj, (bytes, bytearray)):
182 obj = obj.decode("ascii")
183
184 m = DATETIME_RE.fullmatch(obj)
185 if not m:
186 return convert_date(obj)
187
188 try:
189 groups = list(m.groups())
190 groups[-1] = _convert_second_fraction(groups[-1])
191 return datetime.datetime(*[int(x) for x in groups])
192 except ValueError:
193 return convert_date(obj)
194
195
196TIMEDELTA_RE = re.compile(r"(-)?(\d{1,3}):(\d{1,2}):(\d{1,2})(?:\.(\d{1,6}))?")

Callers

nothing calls this directly

Calls 2

convert_dateFunction · 0.85
_convert_second_fractionFunction · 0.85

Tested by

no test coverage detected