Manikandan Thiagarajan
asked on
Solve my Time stamp Problem in oracle
Solve my Time stamp Problem in oracle
VALUES('1','1','1','1','1' ,TO_TIMEST AMP(TO_CHA R('02-02-2 011 12:12:16','DD-MM-YYYY HH24:MI:SS')),
in time stamp it would provide invalid number
could you please give me the correct syntax in Timestam
VALUES('1','1','1','1','1'
in time stamp it would provide invalid number
could you please give me the correct syntax in Timestam
ASKER
please correct this one it would throw invalid number in time stamp format
INSERT INTO com_ebpp_bill_reg_hst
(EBR_LV_CODE_ST
,EBR_BILLER_CODE_ST,
EBR_BILL_UPLOAD_TYPE_ST,
EBR_PAY_PRES_FLAG_ST,
EBR_ACTIVE_STATUS_FLAG_ST,
EBR_BUS_DATE_DT,
EBR_MAKER_ID_ST,
EBR_MAKER_DATETIME_DT,
EBR_CHECKER_ID_ST,
EBR_CHECKER_DATETIME_DT,
EBR_CHANNEL_SOURCE_ST,
EBR_RECRD_STATUS_ST,
EBR_MAKER_REMARKS_ST,
EBR_CHECKER_REMARKS_ST,
EBR_WORK_BR_ID_DO)
VALUES('1','1','1','1','1' ,to_timest amp(TO_CHA R('12-01-2 010 22:12:12' ,'DD-MM-RRRR HH24:MI:SS'),'DD-MM-RRRR HH24:MI:SS')
,
'1',
sysdate,
'1',sysdate,'y','y','y','y ',1)
INSERT INTO com_ebpp_bill_reg_hst
(EBR_LV_CODE_ST
,EBR_BILLER_CODE_ST,
EBR_BILL_UPLOAD_TYPE_ST,
EBR_PAY_PRES_FLAG_ST,
EBR_ACTIVE_STATUS_FLAG_ST,
EBR_BUS_DATE_DT,
EBR_MAKER_ID_ST,
EBR_MAKER_DATETIME_DT,
EBR_CHECKER_ID_ST,
EBR_CHECKER_DATETIME_DT,
EBR_CHANNEL_SOURCE_ST,
EBR_RECRD_STATUS_ST,
EBR_MAKER_REMARKS_ST,
EBR_CHECKER_REMARKS_ST,
EBR_WORK_BR_ID_DO)
VALUES('1','1','1','1','1'
,
'1',
sysdate,
'1',sysdate,'y','y','y','y
Don't put to_char on a string
TO_CHAR('12-01-2010 22:12:12'
'12-01-2010 22:12:12' is already a string
TO_CHAR('12-01-2010 22:12:12'
'12-01-2010 22:12:12' is already a string
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try this
VALUES('1','1','1','1','1' ,TO_DATE(' 02-02-2011 12:12:16','DD-MM-YYYY HH24:MI:SS'),
VALUES('1','1','1','1','1'
did you try what i suggested ?
VALUES('1','1','1','1','1'