I'm lost on how using a varchar doesn't get you the "real time" it takes to load the data.
And you don't change the NLS_DATE format, you match it and use a varchar. That's the only mechanism for loading a date that does not require the use of the TO_DATE function.
insert a date field with ODBC Enterprise stage
Moderators: chulett, rschirm, roy
The issue is solve by using User insert command like:
INSERT
INTO
TBble
(T_ID, T_DATE)
VALUES
(ORCHESTRATE.T_ID, to_date(ORCHESTRATE.T_DATE, 'yyyy/mm/dd'))
In the ODBC enterprise stage, I declare t_date varchar;
in open command property I use this query : TRUNCATE TABLE TBble;
Thanks all of you for helping me;
INSERT
INTO
TBble
(T_ID, T_DATE)
VALUES
(ORCHESTRATE.T_ID, to_date(ORCHESTRATE.T_DATE, 'yyyy/mm/dd'))
In the ODBC enterprise stage, I declare t_date varchar;
in open command property I use this query : TRUNCATE TABLE TBble;
Thanks all of you for helping me;
The issue is solve by using User insert command like:
INSERT
INTO
TBble
(T_ID, T_DATE)
VALUES
(ORCHESTRATE.T_ID, to_date(ORCHESTRATE.T_DATE, 'yyyy/mm/dd'))
In the ODBC enterprise stage, I declare t_date varchar;
in open command property I use this query : TRUNCATE TABLE TBble;
Thanks all of you for helping me;
INSERT
INTO
TBble
(T_ID, T_DATE)
VALUES
(ORCHESTRATE.T_ID, to_date(ORCHESTRATE.T_DATE, 'yyyy/mm/dd'))
In the ODBC enterprise stage, I declare t_date varchar;
in open command property I use this query : TRUNCATE TABLE TBble;
Thanks all of you for helping me;