You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
506 B
SQL
20 lines
506 B
SQL
|
|
/*
|
|
시작 시간을 넘기면 시간을 1시간 범위로 생성하여 돌려준다.
|
|
- ex) in : '07', out : '07:00~08:00'
|
|
*/
|
|
CREATE OR REPLACE FUNCTION FUN_ONE_HOURS
|
|
(
|
|
in_hour IN CHAR -- RFID 구분
|
|
) RETURN CHAR
|
|
IS
|
|
out_hours CHAR(11); -- 0:rfid금액제외, 1:rfid금액포함
|
|
BEGIN
|
|
SELECT in_hour||':00'||'~'||DECODE(LENGTH(TO_CHAR(TO_NUMBER(in_hour)+1)),1,'0'||TO_CHAR(TO_NUMBER(in_hour)+1),TO_CHAR(TO_NUMBER(in_hour)+1))||':00'
|
|
INTO out_hours
|
|
FROM DUAL;
|
|
|
|
RETURN out_hours;
|
|
END;
|
|
/
|