TIMESTAMP

TIMESTAMP data is stored as a 64-bit unsigned integer and represents a quantity in microseconds. You can compute a binary TIMESTAMP value for a given year, month, day, hour, minute, second, and microsecond as follows:

Compute binaryDateValue for the date as shown above.

Compute binaryTimeValue for the time as shown above.

binaryDateTimeValue = binaryDateValue *
    86400000000 + binaryTimeValue