date in oracle 9i

[pongal]

hi,

one of oracle 9i table has field indate with datatype timestamp.
when i am inserting the data on that field using this logic
OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:")
value is storing like this 15-AUG-05 0
suppose if i use this logic
OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:") : " ." : FIELD(TIME(),'.',2)
it's throwing an error saying in"BASIC_Transformer_1,0: Returned timestamp format not recognised for field - indate. Unable to set to Null"

Can anybody help me out how to insert current date on the field having datatype as timestamp.

[ray.wurlod]

You should not have a space ahead of the seconds/milliseconds separator, but you have specified " ." (space dot).