Interval in python-sql query

Support Developer
1

Hello:
Using the python-sql library, is it possible to write a query that contains the ‘interval’ operator, for example a query like the following where ‘date_time_att’ is of type DateTime?:

select date_time_att - interval ‘3 hours’ from zktime_zkline;

2

You can use datetime.timedelta in your query as long as the library you use to connect to the database support it.