PostgreSQL Invalid Syntax

I have this in the where clause of my SQL query:

‘2023/10/21 14:46:32.805068000’ + interval ‘1 second’

This causes me to have an "invalid input syntax for type interval" error.

Does anyone have a suggestion?

>Solution :

You need to have a timestamp datatype to calculate .

SELECT '2023/10/21 14:46:32.805068000'::timestamp + interval '1 second'

SELECT 1

fiddle