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"
date format to insert into oracle table
Moderators: chulett, rschirm, roy
pongal,
Iconv/Oconv don't work in Parallel extender. You should use StringToTimestamp(in.DateString,[optional formatting])
Iconv/Oconv don't work in Parallel extender. You should use StringToTimestamp(in.DateString,[optional formatting])
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>