Friends, I have the following problem:
SELECT TO_DATE(TO_CHAR(B.START_DATE,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS') START_DATE, FROM table1
Output:
23-06-2018 13:50:56
But when you insert it in the other table it does so as:
23-06-2018
Why?
Search found 17 matches
- Wed Jul 04, 2018 10:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date format: time being truncated
- Replies: 2
- Views: 13159
- Fri Jun 08, 2018 8:52 am
- Forum: General
- Topic: Error delete
- Replies: 3
- Views: 3009
Error delete
why do you give me this error when trying to erase? 2018-06-08 10:35:34,028 INFO com.ibm.datastage.g11n.DataStageSessionLocale.setISFSessionLocale(DataStageSessionLocale.java:167) - Setting ISFSession locale to 'en_US' for 'B1B453C9-CEEE-4A90-BE97-71BF6878760D' 2018-06-08 10:35:34,232 INFO com.ascen...
- Wed May 23, 2018 8:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: input parameters pl/sql
- Replies: 2
- Views: 13702
- Wed May 16, 2018 3:18 pm
- Forum: General
- Topic: lost discussion
- Replies: 3
- Views: 3528
- Wed May 16, 2018 10:29 am
- Forum: General
- Topic: lost discussion
- Replies: 3
- Views: 3528
- Wed May 16, 2018 9:39 am
- Forum: General
- Topic: lost discussion
- Replies: 3
- Views: 3528
lost discussion
friends yesterday leave a query here and today I was checking and my query is not out. Can I know why?
- Tue May 15, 2018 10:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: input parameters pl/sql
- Replies: 2
- Views: 13702
input parameters pl/sql
friends I have a doubt if they can help me I have the following simple example I leave in a photo 1 select * from table 2 insert into table prueba_mr that works perfectly what ace is the following https://ibb.co/guRpdy what you need to do is replace the select with an anonymous block pl / sql and go...
- Thu May 10, 2018 12:58 pm
- Forum: General
- Topic: validate the existence of a file
- Replies: 9
- Views: 4934
- Wed May 09, 2018 10:29 am
- Forum: General
- Topic: validate the existence of a file
- Replies: 9
- Views: 4934
- Wed May 09, 2018 9:13 am
- Forum: General
- Topic: validate the existence of a file
- Replies: 9
- Views: 4934
validate the existence of a file
FRIENDS FROM datastage I need to validate if there is a file who can show me an example
- Mon May 07, 2018 3:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Insert into with pl / sql
- Replies: 2
- Views: 13488
- Mon May 07, 2018 3:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Insert into with pl / sql
- Replies: 2
- Views: 13488
- Mon Apr 30, 2018 3:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Declare select * from dual end
- Replies: 3
- Views: 14024
Re: Declare select * from dual end
I need to improve a query and for that I need to use variable before the query
it's possible??
it's possible??
- Mon Apr 30, 2018 8:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Declare select * from dual end
- Replies: 3
- Views: 14024
Declare select * from dual end
friends within the query section I can use a declare
???
?????
???
?????
- Fri Apr 20, 2018 9:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-00955: name is already used by an existing object
- Replies: 1
- Views: 2881
ORA-00955: name is already used by an existing object
you know what this error means:
Carga_02..ouput_02: Exception thrown from CC_OraUtils::handleBeforeAfterSQL, file CC_OraUtils.cpp, line 4722: The OCI function executeDirect returned status -1. Error code: 955, Error message: ORA-00955: name is already used by an existing object.
Carga_02..ouput_02: Exception thrown from CC_OraUtils::handleBeforeAfterSQL, file CC_OraUtils.cpp, line 4722: The OCI function executeDirect returned status -1. Error code: 955, Error message: ORA-00955: name is already used by an existing object.