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)
| 164 | |
| 165 | |
| 166 | def 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 | |
| 196 | TIMEDELTA_RE = re.compile(r"(-)?(\d{1,3}):(\d{1,2}):(\d{1,2})(?:\.(\d{1,6}))?") |
nothing calls this directly
no test coverage detected