Abbreviation of Month Name in formatDateTime

[Mai Abdel-Qader]

Hello,

How can I get the abbreviation of month name (e.g: Jan, Feb, .. etc) using formatDateTime?

Thanks a lot,

Mai

[Denis Zhuravlev]

No. You cannot.

only manually

WITH
    (
        SELECT ['Jan', 'Feb', 'Mar', 'Apr']
    ) AS m
SELECT
    d,
    m[d]
FROM
(
    SELECT 4 AS d
    UNION ALL
    SELECT 1
)

┌─d─┬─arrayElement(m, d)─┐
│ 1 │ Jan                │
└───┴────────────────────┘
┌─d─┬─arrayElement(m, d)─┐
│ 4 │ Apr                │
└───┴────────────────────┘