date format to insert into oracle table
Posted: Wed Aug 17, 2005 10:44 am
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"
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"