When aging data, I have some specific requirements that must be met. I am using a column map procedure to meet this need. One of my requirements is that the time portion of the source column's timestamp remain unchanged. I am able to extract all of the necessary components of the timestamp except for the fractions of a second. Extracting fractions of seconds is crucial for my application. Below is my method of extracting the the timestamp from the source column. I have been unable to find any information about extracting fractions of a second. Does Optim Basic provide any way of extracting fractions of a second from the source column's timestamp? Is there a better/more effective way to accomplish my goal, that includes support for fractions of a second? Should I be using an Exit Routine instead of a column map? Is an Exit Routine capable of providing the functionality I need?
/* Extract the timestamp from the source column*/
/* Age the Data */
/* Insert the aged timestamp into the destination column */
Target.Value = adj_datetime