Database Time Value Compatibility Problem

• Desktop application stores date-time values as a formatted string without time-zone information in local time.
• Mobile application stores date-time values as a formatted string without time-zone information in UTC time.

Data must be stored in same manner because of possible transfers between the applications.

Proposed Solution:

• Store time as a formatted string with time zone information.
• Interpret data without time-zone in local time. - This will reman compatibility with desktop application but skew stored times in mobile application.

see datovka#747 (closed)