CREATE OR REPLACE FUNCTION SF_YYPT_CALMZSJ(
as_GHQSSJ in char, --挂号开始时间
as_GHJSSJ in char  --挂号结束时间
)
return char is
  ls_result char(1);
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- wbx         2022.01.27  修改函数名称
-- ---------   ----------  --------------------------------------------------
begin
  if as_GHJSSJ<='12:30:00' and as_GHQSSJ>='07:00:00'  then ls_result:='A';
  --elsif  as_GHQSSJ>'12:00:00' and as_GHJSSJ<='18:00:00' then ls_result:='P';
  elsif  as_GHQSSJ>'13:00:00' and as_GHQSSJ<'18:00:00' then ls_result:='P';
  elsif  as_GHQSSJ>='07:00:00' and as_GHJSSJ<='23:00:00' then ls_result:='F';
  else  ls_result:='N';
  end if;
  return ls_result;
end;