date format to insert into oracle table

[pongal]

hi,
i want to insert date and time in oracle date format and the field datatype is timestamp.

for eg:- 8/17/2005 11:35:15 AM
can anybody give the exact function in ds.

i have tried oconv(iconv(@Date,"DYMD"),"D/MDY[2,2,4]"):" ":oconv(@Time,"MTHS")
but i am getting an error "Returned timestamp format not recognised for field EXPDATE"

[ArndW]

pongal,

Iconv/Oconv don't work in Parallel extender. You should use StringToTimestamp(in.DateString,[optional formatting])