Handling Time through stages

Sreenivas · Post by **Sreenivas** » Wed Sep 20, 2006 3:14 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 3:30 pm

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.

kumar_s · Post by **kumar_s** » Wed Sep 20, 2006 6:38 pm

It is the 'Time' datatype which occupies 8Bytes.

Sreenivas · Post by **Sreenivas** » Fri Sep 22, 2006 9:26 am

kumar_s wrote:It is the 'Time' datatype which occupies 8Bytes. ...

Hi,

Thanks for your response, i see size of Time data type on DB2 database as 3 and it accepts '12:00:00' this value to update or insert. It just do not accept through Ascential.
Please suggest me.

Sree