Best practice forum (Archived)

Time / Date format stored in Appraisal Tables?

 
John Unnever
Time / Date format stored in Appraisal Tables?
by John Unnever - Tuesday, 2 February 2016, 11:08 AM
Group Partners

Hello!  

Just curious if anyone can tell me what format some of the date / time fields are using in the mdl_appraisal* tables?  For instance, in mdl_appraisal the 'timestarted' column has a value of '1448397341' .  

Is there any way to get this column data into a more human readable format by default so we don't have to manipulate it after the fact?

1448397341

 
Permalink | Reply
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

 
Permalink | Show parent | Reply