Best practice forum (Archived)

Time / Date format stored in Appraisal Tables?

 
Floyd Saner
Re: Time / Date format stored in Appraisal Tables?
by Floyd Saner - Tuesday, 2 February 2016, 11:33 AM
 

John,

The data format is Unix time - very commonly used in database systems. There is a conversion command in SQL, FROM_UNIXTIME, see https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_from-unixtime

Floyd