Timestamp to internal format

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
wannabexpert
Participant
Posts: 13
Joined: Mon Sep 11, 2006 8:01 am

Timestamp to internal format

Post by wannabexpert »

Is there a way to convert timestamp to internal format? I know about ICON/OCON functions a little bit,But I cant find this type of conversion in the document or using help in DS.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Curious why you would need one in internal format? What are you planning on doing with it in that state? Typically you would convert the two portions separately using IConv with 'D' and 'MTS'...
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DateStage does not have an internal format for timestamp. It does for date and for time, but not for timestamp. You can, of course, convert a timestamp to the number of seconds since a zero point, but converting the date portion to days and the time portion to seconds then performing the requisite arithmetic.

But, as Craig asks, why?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply