DSXchange

HI,

i am getting the two fields from source file ( one is Date field, second field is Time field). The datatype of two fields is varchar. That two fields ( Date and Time) needs to converted as combination of DateTime, datatype is Timestamp.

Pl give me the possibility,

Thanks,

Use StringToDate and StringToTime functions

StringToDate(Dt,"%yyyy-%mm-%dd") : StringToTime(Tm,"%hh:%nn:%ss")

Why not StringToTimestamp(InLink.TheDate : " " : InLink.TheTime) ? If course your elements need to be in the appropriate ISO 8601 format for this to work.