How to fix data type error?

Question

PostgreSQL

I make a request

INSERT INTO data.source(id, created, created_utc) VALUES($1, to_timestamp('$2'), to_timestamp('$3'))

I get an error

error: invalid input syntax for type double precision: "$2"

What's wrong? In my database, the type of this field is timestamp , and he rubs me about double .
Inserted Value 1581569438

In the documentation , to_timestamp takes double precision - is n't the number I'm returning a double ? (I do it in js, forced this value to a number) to_timestamp(double precision)

Answer 1

For some reason, the value of the variable "$2" is not substituted in your code and the string '$2' is transferred to the database, not a number.
Have a look at SQL fiddle