In order to migrate the POSGRE database to AWS dynamicb, we would like to extract it in json format first.

There are about two problems with SQL mentioned in the questionnaire.

If you still get errors after dealing with these two points, please post a new question with the error message you see.

• If you specify a date and time, there must be a space between

I think the revised SQL will be as follows.

SELECT to_json(table_100)
FROM table_100
WHERE date (timestamp) BETWEEN'198707050010'AND'20200705 2400';

Also, since I use date(), I think specifying the time makes little sense. For '20200705 2400', 2020-07-06 data cannot be retrieved.

If you also want to retrieve data for 2020-07-06, change the condition to '2020-07-06' or '20200706'.
(If there is no problem with the data up to '2020-07-05', there is no need to modify it.)

Refer to the documentation for an example of the date format available in PostgreSQL.

https://www.postgresql.jp/document/12/html/datatype-datetime.html#DATATYPE-DATETIME-DATE-TABLE