DSXchange

Hi,

if you need default time to be added to the date part then you can go for following conversion.

StringToTimestamp(DateToString(DSLink2.da,"%yyyy-%mm-%dd") : ' 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")

thanks.

can you please tell the type of file? means fixed width or delimited?

check somewhere in column level properties default value has been set to the value which you are finding for the field.

could you please be more specific

are you asking about oracle stage before/after statement? Is your project is in protected mode? r u loged in with prod manager profile?