edit data for json column with bigint
Posted by:
Lion Hawk
Date: November 07, 2017 02:34AM
I have a table named "t_flow_sheet",and it have a json type column named "FORM_JSON".
when I run sql script:
SELECT json_extract(FORM_JSON,"$.*.createTime") from t_flow_sheet LIMIT 1;
Then I get a result grid:
[1509588087000]
it is correct.
but I open value in viewer,I get
[
-2147483648
]
How I can get correct value when edit data for json ?
Subject
Views
Written By
Posted
edit data for json column with bigint
509
November 07, 2017 02:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.