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.
binaryDateTimeValue = binaryDateValue * 86400000000 + binaryTimeValue