Datetime column gives unexpected format in python for Postgres table [duplicate]

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
– Shabari nath k, Commented Jul 6, 2020 at 11:00
Please clarify: do you mean it's a tuple with a datetime object inside? — FObersteiner
– FObersteiner, Commented Jul 6, 2020 at 11:02

Thangarajan Pannerselvam · Accepted Answer · 2020-07-06 10:50:04Z

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 6, 2020 at 10:50

1562 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Din work ..Error :'tuple' object has no attribute 'strftime'

try x[0]..strftime('%Y-%m-%d %H:%M:%S')

records[0][0].strftime('%Y-%m-%d %H:%M:%S') worked ..