MariaDB failing to recognize CONVERT_TZ SQL function

bfrank

I am trying to run the function below but it keeps returning null because, it looks like, proper TimeZone modules are not installed for MariaDB 10.4.3 which I intalled with aaPanel's one click installer.

AI based help failed because, likely, of the unique way MySQL/Maria is installed via aaPanel on Ubuntu. Help is great appreciated so I can properly use this function to convert dates.

UPDATE your_table_name
SET datetimetest = CONVERT_TZ(
    STR_TO_DATE(tf_date_created_format, '%m/%d/%Y %l:%i %p'),
    'America/New_York',
    'UTC'
);