Title: 错误: 字段 "date" 的类型为 timestamp without time zone, 但表达式的类型为 bigint · Issue #833 · APIJSON/APIJSON · GitHub
Open Graph Title: 错误: 字段 "date" 的类型为 timestamp without time zone, 但表达式的类型为 bigint · Issue #833 · APIJSON/APIJSON
X Title: 错误: 字段 "date" 的类型为 timestamp without time zone, 但表达式的类型为 bigint · Issue #833 · APIJSON/APIJSON
Description: 环境信息 系统: 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/APIJSO...
Open Graph Description: 环境信息 系统: 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/...
X Description: 环境信息 系统: Windows 11 10.0 数据库: POSTGRESQL 14.7 JDK: 21.0.2 amd64 APIJSON: 8.0.0 问题描述 后端数据库为Postgresql,传入参数如下: { "User": { "sex": 0, "name": "", "tag"...
Opengraph URL: https://github.com/APIJSON/APIJSON/issues/833
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"错误: 字段 \"date\" 的类型为 timestamp without time zone, 但表达式的类型为 bigint","articleBody":"**环境信息**\n系统: Windows 11 10.0\n数据库: POSTGRESQL 14.7\nJDK: 21.0.2 amd64\nAPIJSON: 8.0.0\n**问题描述**\n后端数据库为Postgresql,传入参数如下:\n{\n \"User\": {\n \"sex\": 0,\n \"name\": \"\",\n \"tag\": \"\",\n \"head\": \"https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png\",\n \"contactIdList\": null,\n \"pictureList\": null,\n \"date\": 1751286600000\n },\n \"tag\": \"User\",\n \"@explain\": true\n}\n其中data字段用上面的时间戳,或者字符串\"yyyy-mm-dd hh:mm:ss\",或者\"now()\",都不行,后台是timestamp,JON参数该如何传值?","author":{"url":"https://github.com/bjzhaoxy","@type":"Person","name":"bjzhaoxy"},"datePublished":"2025-07-25T07:13:16Z","url":"https://github.com/APIJSON/APIJSON/issues/833"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:d8af7d16-f075-b51c-ddf9-21894e2b3cf9 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | A71A:16B944:1A5AC5:242852:6AFCA9AD |
| html-safe-nonce | 40c2842229eb569586772403e73d0cba0198a85078470e7c027a3915166cf1d8 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNzFBOjE2Qjk0NDoxQTVBQzU6MjQyODUyOjZBRkNBOUFEIiwidmlzaXRvcl9pZCI6Ijg2MjYzMTUwODc0ODA1MjkxMCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | ea7ea4c49819eb7f4610cc8b46e46e8e47726798553e3fca12075346231c83c0 |
| hovercard-subject-tag | issue:3262242237 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/APIJSON/APIJSON/833/issue_layout |
| twitter:image | https://opengraph.githubassets.com/9cc6db3b2e24fc46e95dec45f22e89a7bd074430247de870c7ce24e7123bf9a8/APIJSON/APIJSON/issues/833 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/9cc6db3b2e24fc46e95dec45f22e89a7bd074430247de870c7ce24e7123bf9a8/APIJSON/APIJSON/issues/833 |
| og:image:alt | 环境信息 系统: 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/... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | bjzhaoxy |
| hostname | github.com |
| expected-hostname | github.com |
| None | e3084aead77cbcb4f4904fba53851fa1a0546b0dec3619bd250815e72588dc6d |
| turbo-cache-control | no-preview |
| go-import | github.com/APIJSON/APIJSON git https://github.com/APIJSON/APIJSON.git |
| octolytics-dimension-user_id | 41146037 |
| octolytics-dimension-user_login | APIJSON |
| octolytics-dimension-repository_id | 74359442 |
| octolytics-dimension-repository_nwo | APIJSON/APIJSON |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 74359442 |
| octolytics-dimension-repository_network_root_nwo | APIJSON/APIJSON |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5410e4bebd3e45b138c853ecef3992279d86d5af |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width