Untitled

 avatar
unknown
plain_text
a year ago
974 B
2
Indexable
still iam getting NaT in the query actually that sould be replaced with NULL 

INSERT INTO tibtcare_ppm_st.ppm_product_pff_map (product_pff_map_nbr, product_pff_map_id, order_line_action, service_type, product_spec_id, product_type_id, product_action, pff_id, pff_default_state, start_date, end_date, created_by, created_on, updated_by, updated_on, bu_id, operator_id, external_sys_id, external_sys_catg, product_default_value, catalog_id, dataset_id, instant_billing, rollback_pff_id, override_action, off_set, base_date) VALUES ('19439', 'PO_Mobile_Service_Optimi_Package-PF_1968', 'ADD_SUBSCRIPTION', 'Mobile', 'PO_Mobile_Service_Optimi_Package', NULL, 'I', 'CFSS_MOBILE_SUBSCRIBER', 'ON', TO_DATE('2018-07-09 13:18:31', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2030-12-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS'), '751482', TO_DATE('2018-07-09 13:18:31', 'YYYY-MM-DD HH24:MI:SS'), NULL, 'NaT', 'DEFAULT', 'HOB', 'SOM-EOC', 'NETWORK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)