Datetime column gives unexpected format in python for Postgres table

Question

This is the query i am trying to run in a python file

cur.execute(f"(select data_end_time from table;))
records = cur.fetchall()")
print(records[0])

This is the Output i am getting

datetime.datetime(2020, 7, 6, 17, 0)

Expected output

2020-07-06 17:00:00

records[0] contains value datetime.datetime(2020, 7, 6, 17, 0) and is of type tuple

records[0] contains value datetime.datetime(2020, 7, 6, 17, 0),and is of type tuple — Shabari nath k, Jul 06 '20 at 11:00
Please clarify: do you mean it's a tuple with a datetime object inside? — FObersteiner, Jul 06 '20 at 11:02

score 0 · Answer 1 · answered Jul 06 '20 at 10:50

0

You have to use datetime.strftime for converting datetime object into string

import datetime

x = datetime.datetime(2020, 7, 6, 17, 0)

print(x.strftime('%Y-%m-%d %H:%M:%S')

#output
'2020-07-06 17:00:00'

answered Jul 06 '20 at 10:50

Din work ..Error :'tuple' object has no attribute 'strftime' – Shabari nath k Jul 06 '20 at 10:56
try x[0]..strftime('%Y-%m-%d %H:%M:%S') – Thangarajan Pannerselvam Jul 06 '20 at 10:57
records[0][0].strftime('%Y-%m-%d %H:%M:%S') worked .. – Shabari nath k Jul 06 '20 at 11:06

1 Answers1