Server Job to Parallel Job Basic string conversion

koojo · Post by **koojo** » Mon Sep 25, 2006 10:23 am

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

manojkumarnayak · Post by **manojkumarnayak** » Mon Sep 25, 2006 10:33 am

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

koojo · Post by **koojo** » Mon Sep 25, 2006 10:46 am

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...?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 25, 2006 3:03 pm

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.

keshav0307 · Post by **keshav0307** » Tue Sep 26, 2006 6:28 am

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.