Hi,
I know date and datetime is handled through Timestamp as data type and with 19 length.
Can someone tell me how Time can be handled like what data type and length to be considered and if we have to hard code the value like '13:00:00' how is it handled.
Thanks in Advance
Sree
Handling Time through stages
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If this is truly time, then the maximum legal value is 23:59:59. If you need 30:00:00 you're really talking about "interval".
There is nothing out of the box in DataStage for working with intervals but, because times are stored internally as seconds, then Mod() and Div() functions can be used to generate interval formats.
There is nothing out of the box in DataStage for working with intervals but, because times are stored internally as seconds, then Mod() and Div() functions can be used to generate interval formats.
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.