Python format date string from postgresql db

Question

I have the following code that extracts a postgres CURRENT_TIMESTAMP from a database

cursor.execute("SELECT submitdate FROM journeys WHERE display = true")
submitDate = cursor.fetchone()['submitdate']

which returns

2015-08-11 12:44:31.790462

How would I format this to show as 11-08-2015 for example?

I've read about and tried things such as this but they don't work

print(
    datetime.datetime.fromtimestamp(
        int("1284101485")
    ).strftime('%Y-%m-%d %H:%M:%S')
)

He wants 11-08-2015 then it shoud be submitDate.strftime("%d-%m-%Y") — Abhis
– Abhis, Commented Aug 11, 2015 at 14:15

malizia · Accepted Answer · 2017-07-15 16:19:13Z

2

The solution that worked comes from Abhis's comment above.

submitDate.strftime("%d-%m-%Y")

malizia

255 bronze badges

answered Jul 5, 2017 at 14:11

winseybash

7023 gold badges12 silver badges27 bronze badges

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

1 Answer 1