-
Notifications
You must be signed in to change notification settings - Fork 616
Description
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
如何处理这类问题?