MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.3.9-MariaDB-1:10.3.9+maria~stretch-log

set session sql_mode='NO_ZERO_DATE,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
SELECT STR_TO_DATE( '03:57:AM', '%h:%i:%p' )

STR_TO_DATE( '03:57:AM', '%h:%i:%p' )

03:57:00

show variables like 'sql_mode'

Variable_name
Value

sql_mode
STRICT_TRANS_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION