'Convert UTC datetime stored in Postgres DB to given timezone for comparison

I want to convert UTC datetiem stored in postgres db whilte comparing with user given datetime with given zone

data.filter(
                and_(
                    func.timezone(user_time_zone, Table.created_at) >= start_date,
                    func.timezone(user_time_zone, Table.created_at) <= end_date,
                )
            )

This is not working, any suggestions

postgresqltimezone


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions