ITM 6.1 Data Warehouse TimeStamps

The Timestamp attribute in the ITM 6.1 data warehouse is not in a normal database format. It is in a special format.

The format of the timestamp attribute is a 16 character string that has the format of cyymmddhhmmssttt where:

c = century (1 = 2000)

yy = year

mm = month

dd = day

hh = hour

mm = minutes

ss = seconds

ttt = hundredth of seconds

This timestamp makes it hard to do normal timestamp like functions against the data (e.g., report on a time range of data from the database) without creating a special procedure or database function. For more information on on the ITM 6.1 data warehouse see:

http://www.gulfsoft.com/downloads/TDW21.pdf