date in oracle 9i
Posted: Mon Aug 15, 2005 8:42 am
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.
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.