Hello everyone,
I'm beginner in this world, sorry for my simple question.
I wanna insert the current date and time on the database after my application has started the stored procedure.
I have to insert the following format for datetime column: 03/19/2015 00:00:00 (i.e. MM/DD/YYYY XX:XX:XX AM/PM)
Is it correct to use this line?
TO_DATE(SYSDATE, 'MM/DD/YYYY HH24:MI:SS')
--
My SYSDATE example:
SELECT SYSDATE from DUAL;
3/19/2015 5:43:37 PM
-------------
CREATE OR REPLACE PROCEDURE "BD"."PROC" (
p_varCONTACT_INFO NVARCHAR2,
p_varDAILY_FROM NUMBER,
p_varDAILY_TILL NUMBER,
p_varGRUPO_DESTINO VARCHAR2,
p_varPROTOCOLO VARCHAR2,
p_varMCDU VARCHAR2,
p_varCLUSTER_N VARCHAR2,
p_varGRUPO_ORIGEM VARCHAR2,
p_varRP_DESTINO VARCHAR2,
p_varMOTIVO_QUEDA VARCHAR2,
p_varSWITCH_DESTINO VARCHAR2,
p_varACCOUNT_NUMBER_IVR VARCHAR2,
)
AS
BEGIN
INSERT INTO BD.TA_CALLBACK
(
RECORD_ID,
CONTACT_INFO,
CONTACT_INFO_TYPE,
RECORD_TYPE,
RECORD_STATUS,
CALL_RESULT,
ATTEMPT,
DAILY_FROM,
DAILY_TILL,
TZ_DBID,
CHAIN_ID,
CHAIN_N,
GROUP_ID,
SWITCH_ID,
PROTOCOLO,
MCDU,
GRUPO_DESTINO,
RP_DESTINO,
GRUPO_ORIGEM,
MOTIVO_QUEDA,
SWITCH_DESTINO,
DATA,
CAMPO1,
CLUSTER_N
)
SELECT
NVL(MAX(record_id),0) + 1,
p_varCONTACT_INFO,
1,
2,
1,
28,
0,
p_varDAILY_FROM,
p_varDAILY_TILL,
131,
NVL(MAX(chain_id),0) + 1,
0,
8847,
283,
p_varPROTOCOLO,
p_varMCDU,
p_varGRUPO_DESTINO,
p_varRP_DESTINO,
p_varGRUPO_ORIGEM,
p_varMOTIVO_QUEDA,
p_varSWITCH_DESTINO,
TO_DATE(SYSDATE, 'MM/DD/YYYY HH24:MI:SS'),
p_varACCOUNT_NUMBER_IVR,
p_varCLUSTER_N
FROM BD. TA_CALLBACK;
END PROC;
-------------
Environment: Oracle 10g
Best regards,
Henrique Silva