postgresql_query: fix datetime.timedelta type handling (#73520)

1 files changed, 4 insertions, 0 deletions

diff --git a/lib/ansible/modules/database/postgresql/postgresql_query.py b/lib/ansible/modules/database/postgresql/postgresql_query.py
index dc386d6a62..ca056566b0 100644
--- a/lib/ansible/modules/database/postgresql/postgresql_query.py
+++ b/lib/ansible/modules/database/postgresql/postgresql_query.py
@@ -168,6 +168,7 @@ rowcount:
     sample: 5
 '''
 
+import datetime
 import decimal
 
 try:
@@ -312,6 +313,9 @@ def main():
                 if isinstance(val, decimal.Decimal):
                     row[key] = float(val)
 
+                elif isinstance(val, datetime.timedelta):
+                    row[key] = str(val)
+
             query_result.append(row)
     except Psycopg2ProgrammingError as e:
         if to_native(e) == 'no results to fetch':