By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
CASE
WHEN 'October-21' < 'December-21' THEN 'TRUE'
ELSE 'FALSE'
END AS string_comp_test
, CASE
WHEN DATE '2021-10-01' < DATE '2021-12-01' THEN 'TRUE'
ELSE 'FALSE'
END AS date_comp_test
;
| string_comp_test | date_comp_test |
|---|---|
| FALSE | TRUE |