DSXchange

DSguru2B wrote:Use simple logical operators >,<,= etc. Also for date comparisons, either convert it in YYYY-MM-DD format or to internal format.

I can't use to_date or to_char in datastage, so how can I write it. I appreciate any input

Hi,

In transformer I am applying logic where I have to select date between
(for example:1/1/2000 and 12/31/2000). Can anyone please help me how to write this date logic in datastage? I am new to all of this.

Thanks

Is there any BETWEEN function in datastage like we have in oracle. If not, what can I use for between.

Hi,

I am trying to load data into table.

source data for date is 1/1/2007
target table date format is 1-jan-07

how can i solve this.

Thanks

In the expression that i provided earlier, "in.Col" is your input column. You need to replace that with your inputlink.columnname. ... Thanks so much function worked but I am getting another error now SQLSTATE=22008, DBMS.CODE=0 [DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field ov...

Welcome Aboard :P Use the Field Function. Use DataStage help to see how it works. For your problem, use this Field(in.Col, " ",1) I used this function. I am getting this error. Field(in.Col, "0:00:00 ",1) it returned "1/1/2" Please correct me if I am doing this wrong.

Hi,

I am trying to truncate part of the string. This is the raw data.

1/1/2007 0:00:00

I only need date from this. How can i extract only the date.
I used Left function, not working. Is there any truncate function in datastage that I can use.

Thanks