DSXchange

Hi

I am checking an input coloumn(timestamp),If it is blank
(white spaces),which is not a null value.Then i have to set to 01/01/1800.

input(timestamp) and output stages(date) are DB2

I tried If (input coloumn) = " " then StringToDate('01/01/1800',"%MM/%DD/%YYYY").

Then it is giving an error "APT_CombinedOperatorController(0),0: Data string ' ' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy."

Thanks

Hi Ther can anyone tell me how to post a new Question?\

Top Left : Post New Topic

Try if (InputColumn) = '' then 01/01/1800

From your post it is clear that your input is timestamp or blank value, but what is your input datatype , is it Timestamp or string. what is your output datatype Date or Timestamp. Accordingly you can convert it to TimeStampToDate or DateToTimeStamp.

But Why StringToDate ?