date format like oracle NLS_CALENDAR

[mbtolou]

Hi

can you implement NLS_CALENDAR like oracle :

select TO_CHAR(SYSDATE, 'MM/DD:HH24', 'NLS_CALENDAR=PERSIAN') from dual

[qoega]

ClickHouse is an OpenSource product, so you can try to implement it yourself.
https://github.com/ClickHouse/ClickHouse/blob/master/CONTRIBUTING.md

[alexey-milovidov]

@qoega Supporting different kind of calendars: Persian, Thai, Julian... - is not an easy task to do in general.

Maybe we can just do a shortcut by using fixed shift amounts in days. But it still requires research.

[alexey-milovidov]

A link for curious readers: https://zachholman.com/talk/utc-is-enough-for-everyone-right

[mbtolou]

I use join table with date column

SELECT joinGet('DATE_INFO_DICT', 'SHAMSI', today())