Add function DATE_FORMAT as a compatibility alias. #46184
Description
Use case
Compatibility with MySQL.
Describe the solution you'd like
- Make it a synonym of
formatDateTime. - Add the support for
%iand other missing format substitutions. - Fix the error code from ILLEGAL_COLUMN to a more appropriate one.
milovidov-desktop :) SELECT DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s')
SELECT DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s')
Query id: c24c519d-9f35-48a3-9ada-f9af8b4911a1
0 rows in set. Elapsed: 0.160 sec.
Received exception:
Code: 46. DB::Exception: Unknown function DATE_FORMAT: While processing DATE_FORMAT(now(), '%Y-%m-%d %H:%i:%s'). (UNKNOWN_FUNCTION)
milovidov-desktop :) SELECT formatDateTime(now(), '%Y-%m-%d %H:%i:%s')
SELECT formatDateTime(now(), '%Y-%m-%d %H:%i:%s')
Query id: ab5ea92d-6026-4cc5-bdf9-6b8a8e8f77b4
0 rows in set. Elapsed: 0.002 sec.
Received exception:
Code: 44. DB::Exception: Wrong syntax '%Y-%m-%d %H:%i:%s', unexpected symbol 'i' for function formatDateTime: While processing formatDateTime(now(), '%Y-%m-%d %H:%i:%s'). (ILLEGAL_COLUMN)
milovidov-desktop :)