要在 PostgreSQL 中将日期格式从 10-22 更改为 Oct-22，您可以使用 TO_CHAR 函数。此函数允许您以各种方式格式化日期，例如：
SELECT
TO_CHAR(TO_DATE('10-22', 'MM-YY'), 'Mon-YY') AS formatted_date
在此 SQL 语句中：
TO_DATE('10-22', 'MM-YY')使用MM-YY格式将字符串10-22转换为日期类型。TO_CHAR(..., 'Mon-YY')然后将此日期格式化为显示缩写的月份名称后跟年份，结果为Oct-22。
以下是基于上面共享的 Topics with No Response 查询的 interval 参数的另一个示例：
-- [params]
-- date :start_date = 2024-01-01
-- date :end_date = 2025-01-01
-- null int :category_id
-- boolean :include_subcategories = false
-- text :interval = month
WITH no_response_total AS (
SELECT *
FROM (
SELECT t.id, t.created_at, MIN(p.post_number) first_reply
FROM topics t
LEFT JOIN posts p ON p.topic_id = t.id AND p.user_id != t.user_id AND p.deleted_at IS NULL AND p.post_type = 1
WHERE t.archetype <> 'private_message'
AND t.deleted_at ISNULL
AND (
:category_id IS NULL
OR t.category_id = :category_id
OR (
:include_subcategories
AND t.category_id IN (
SELECT id FROM categories WHERE parent_category_id = :category_id
)
)
)
GROUP BY t.id
) tt
WHERE tt.first_reply IS NULL OR tt.first_reply < 2
)
SELECT
TO_CHAR(date_trunc(:interval, nrt.created_at)::date, 'Mon-YY') AS period,
COUNT(nrt.id) AS topics_without_response
FROM no_response_total nrt
WHERE nrt.created_at::date BETWEEN :start_date AND :end_date
GROUP BY period, date_trunc(:interval, nrt.created_at)::date
ORDER BY date_trunc(:interval, nrt.created_at)::date ASC
供参考，此查询的结果将如下所示：
| period | topics_without_response |
|---|---|
| Dec-23 | 123 |
| Jan-24 | 455 |
| Feb-24 | 789 |
| … | … |