Skip to content

[FEATURE]关于时间查询的处理 #919

@newmann

Description

@newmann

SQLBot version
1.6.0社区版
Please describe your requirements or suggestions for improvement
数据库为SQLBot自身的数据库,

问题:2026年2月份创建的账户有哪些?

返回的SQL:
SELECT "account" AS "account",
"name" AS "name",
"email" AS "email",
TO_CHAR(TO_TIMESTAMP("create_time"), 'YYYY-MM-DD HH24:MI:SS') AS "create_time_formatted"
FROM "public"."sys_user" "u"
WHERE EXTRACT(YEAR
FROM TO_TIMESTAMP("u"."create_time")) = 2026
AND EXTRACT(MONTH
FROM TO_TIMESTAMP("u"."create_time")) = 2
ORDER BY "u"."create_time"
LIMIT 1000

其实是错误的,应该为:
SELECT "account" AS "account",
"name" AS "name",
"email" AS "email",
TO_CHAR(TO_TIMESTAMP("create_time" / 1000), 'YYYY-MM-DD HH24:MI:SS') AS "create_time_formatted"
FROM "public"."sys_user" "u"
WHERE EXTRACT(YEAR
FROM TO_TIMESTAMP("u"."create_time" / 1000)) = 2026
AND EXTRACT(MONTH
FROM TO_TIMESTAMP("u"."create_time" / 1000)) = 2
ORDER BY "u"."create_time"
LIMIT 1000

如何处理这类问题?

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions