SELECT TO_NUMBER(TO_CHAR(TO_DATE('06/14/2018', 'MM/DD/YYYY'), 'WW')) FROM DUAL;
SELECT TO_NUMBER(TO_CHAR(TO_DATE(SYSDATE, 'DD/MM/YYYY'), 'WW')) FROM DUAL;top of page
Related Posts
See AllExample 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...
FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...
Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...
bottom of page
Commentaires