Iniciar sesión
Crear cuenta
Crear cuentaCrear cuenta
...
CASE
WHEN FEC_BIRTHDAYMOM LIKE '0000%' THEN NULL WHEN FEC_BIRTHDAYMOM LIKE '%-00%' THEN NULLELSE TO_DATE(FEC_BIRTHDAYMOM,'YYYY-MM-DD')
END AS FEC_BIRTHDAYMOM,CASE
WHEN FEC_BIRTHDAYBABY LIKE '0000-%' THEN TO_DATE('1990-10-01','YYYY-MM-DD')
WHEN FEC_BIRTHDAYBABY LIKE '%-00%' THEN TO_DATE('1990-10-01','YYYY-MM-DD')
ELSE TO_DATE(FEC_BIRTHDAYBABY,'YYYY-MM-DD')
END AS FEC_BIRTHDAYBABY
...
CREATE FUNCTION ES_FECHA
(FECHA VARCHAR2,RETORNO_ERROR DATE)RETURN DATE
IS
V_DATE DATE;
BEGIN
SELECT TO_DATE(FECHA,'YYYY-MM-DD') INTO V_DATE FROM DUAL;
RETURN V_DATE;
EXCEPTION WHEN OTHERS THEN RETURN RETORNO_ERROR;
END;
CREATE TABLE TMP_MIBEBEYYO_CORE
AS
SELECT COD_ID
, COD_ZIPCODE , STR_EMAIL, ES_FECHA(FEC_BIRTHDAYMOM, NULL) FEC_BIRTHDAYMOM
, ES_FECHA(FEC_BIRTHDAYBABY, TO_DATE('1990-10-01', 'YYYY-MM-DD')) FEC_BIRTHDAYMOM
, TO_NUMBER(SUBSTR(MD5(CAST(COD_ID || COD_ZIPCODE || STR_EMAIL || FEC_BIRTHDAYMOM || FEC_BIRTHDAYBABY AS VARCHAR2(32))||'MIBEBEYYO'),10,16),'XXXXXXXXXXXXXXXX') AS COD_PRODUCT
FROM TMP_MIBEBEYYO;