Python3.7 Convert comma delimited datetime

Asked Dec 27 '19 at 20:33

Active Dec 27 '19 at 20:34

Viewed 34 times

I am reading a date column in a postgresql DB. I would like to convert it from below reading into YYYY-MM-DD (this is how it is entered into the DB originally). What is the best approach to do this?

Code:

dataReading = cursor.fetchall()
print(dataReading[1])

Output:

(datetime.date(2016, 1, 5),)

edited Dec 27 '19 at 20:34

asked Dec 27 '19 at 20:33

Martik

1

what library are you using, `psycopg2`? – gold_cy Dec 27 '19 at 20:34
Correct! psycopg2 – Martik Dec 27 '19 at 20:35
1

Thats the internal representation, `print(dataReading[1][0])` should print a well-formatted date – Maurice Meyer Dec 27 '19 at 20:36
This solved my question! Thank you. print(dataReading[1][0]) – Martik Dec 27 '19 at 20:38
would you rather solve this in the database or on the Python side? – gold_cy Dec 27 '19 at 20:38

Python3.7 Convert comma delimited datetime

0 Answers0