PostgreSQL "to_timestamp" function in RDS Data Service command batchExecuteStatement

0

hi, I'm trying to use the postgresql "to_timestamp" function inside a RDS Data Service batchExecuteStatement calls of the AWS Javascript SDK.

I set the parameterSets to an array. An element of the array is:

{ name: 'received_on', typeHint: 'TIMESTAMP', value: { stringValue: 'to_timestamp(' + record.received_on + ')' } },

where record.received_on is an epoch time like 1644417054153 (I also tested 1644417054.153). The execution of the code throw this error: Cannot parse date or time "to_timestamp(164441704.153)"

Where is the problem? Thanks

Nicola
asked 2 years ago457 views
1 Answer
0

Hi From PostgreSQL doc: https://www.postgresql.org/docs/10/functions-datetime.html

to_timestamp(double precision)

examples in the link indicating something like:

SELECT to_timestamp(982384720.12); Result: 2001-02-17 04:38:40.12+00

Your data to_timestamp(164441704.153) seems to have one more precision.

AWS
SUPPORT ENGINEER
Kevin_Z
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions