an Int64-encoded date and time of the record creation can be used as published property field in TSQLRecord for sftCreateTime: if any such property is defined in the table, it will be auto-filled with the server timestamp corresponding to the record creation use internally for computation an abstract "year" of 16 months of 32 daysof 32 hours of 64 minutes of 64 seconds - faster than TDateTime use TimeLogFromDateTime/TimeLogToDateTime/TimeLogNow/Iso8601ToTimeLogfunctions, or type-cast the value with a TTimeLogBits memory structure fordirect access to its bit-oriented content (or via PTimeLogBits pointer)could be defined as value in a TSQLRecord property as such: property CreatedAt: TModTime read fCreatedAt write fCreatedAt