UPDATE titles_test set to_date = case WHEN to_date = '9999-01-01' THEN NULL else to_date end , from_date = '2001-01-01'