Reg: Timestamp
Moderators: chulett, rschirm, roy
Reg: Timestamp
Hi All,
My target is DB2 one column datatype is timestamp(26) how can i pass Data Stage timestamp value into that field.
DB2 Timestamp format is different and Data Stage farmat is different.
Please give me a suggestion on above matter.
Thanks
My target is DB2 one column datatype is timestamp(26) how can i pass Data Stage timestamp value into that field.
DB2 Timestamp format is different and Data Stage farmat is different.
Please give me a suggestion on above matter.
Thanks
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
What do you mean by DataStage format??? If you mean internal format then it can be manipulated with OCONV. For time, again, use ICONV/OCONV functions with "MTS". But MTS doesnt handle anything lower than seconds. DB2 will add the nano seconds.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am pretty sure Craig. Check thiswebsite out. Scroll down to the heading "Precision". It has a table layed out for timestamp precision for Db2, Oracle and SqlServer. ![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Well, there you go... microseconds it is.
![Cool 8)](./images/smilies/icon_cool.gif)
Code: Select all
DBMS MINIMUM MAXIMUM DEFAULT
DB2 0 6 (to nearest microsecond) 6
Oracle 0 9 (to nearest nanosecond) 6
SQL Sv 0 3 (to nearest millisecond) 3
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because no-one can do it, let's all demand picoseconds!
After all, processors are getting faster. We may need to start talking about partial binary digits.
"It's probably all about quantum"
-- Archchancellor Mustrum Ridcully
![Laughing :lol:](./images/smilies/icon_lol.gif)
After all, processors are getting faster. We may need to start talking about partial binary digits.
"It's probably all about quantum"
-- Archchancellor Mustrum Ridcully
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: