I am trying to get the current date to load into oracle....
I can load the current timestamp by using Convert CurrentTimestamp() into oracle...
If I try to extract the date as YYYY/MM/DD from the above command my job comiles ok,,,,but I cant see the converted data..
I used the following command Convert (Left(CurrentTimestamp(),10),"-","/") This does not work.....I am quiet used to doing string operations with server jobs....Am new to PX jobs
Server Job to Parallel Job Basic string conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Fri Nov 04, 2005 11:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think you want to convert "/" to "-" but you've asked to convert "-" to "/". But why not use SYSDATE ?
Convert() is valid as a function in a parallel Transformer stage.
Convert() is valid as a function in a parallel Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia