Datetime algorithm used in (TimeSpent-)reports
Hello there,
As I am having trouble with the reporting module (see other posts about issues with the Reporting Module, mainly about "FAILURE :Unable to execute report"), I am trying to get some reports from Excel, by using the MySQL ODBC Connector.
All this works fine, but now I have a question. I see date/time-fields converted to numberstrings (like 1191503266944 for a timestamp somewhere in October 2007). Can anyone tell me which datetime-algorithm is used in SDP, so I can convert those strings back to original date/time-fields?
Thanks in advance!
Best regards,
ReneV
As I am having trouble with the reporting module (see other posts about issues with the Reporting Module, mainly about "FAILURE :Unable to execute report"), I am trying to get some reports from Excel, by using the MySQL ODBC Connector.
All this works fine, but now I have a question. I see date/time-fields converted to numberstrings (like 1191503266944 for a timestamp somewhere in October 2007). Can anyone tell me which datetime-algorithm is used in SDP, so I can convert those strings back to original date/time-fields?
Thanks in advance!
Best regards,
ReneV