Skip to content

错误: 字段 "date" 的类型为 timestamp without time zone, 但表达式的类型为 bigint #833

@bjzhaoxy

Description

@bjzhaoxy

环境信息
系统: Windows 11 10.0
数据库: POSTGRESQL 14.7
JDK: 21.0.2 amd64
APIJSON: 8.0.0
问题描述
后端数据库为Postgresql,传入参数如下:
{
"User": {
"sex": 0,
"name": "",
"tag": "",
"head": "https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png",
"contactIdList": null,
"pictureList": null,
"date": 1751286600000
},
"tag": "User",
"@Explain": true
}
其中data字段用上面的时间戳,或者字符串"yyyy-mm-dd hh:mm:ss",或者"now()",都不行,后台是timestamp,JON参数该如何传值?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions