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.
date in oracle 9i
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Watch This Space
You should not have a space ahead of the seconds/milliseconds separator, but you have specified " ." (space dot).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.