DSXchange

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

I think you can use CurrentDate() or CurrentTimestamp().
In oracle user defined query you can use SYSDATE.
let me know your requirement

I tried CurrentDate() would not work...(It gave me a compile time error)...

Have to add an If Then Else in there and dont want to use Sysdate....Am not sure if I am missing something here with PX....or we not able to execute some routines in DS because we are missing some header files...?

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.

your requirement is not clear..
if you are loading currentdate, why you need to convert any format..
if still you want then you can user user defined query and convert the sysdate in what ever format you want.