Personally, when in doubt I prefer the Unix timestamp, which can be stored as a straight number in a varchar or text field in a database and which – as far as I know – all systems can use.
From: Thomas White, MD, MS, MA [mailto:email@example.com]
Sent: Tuesday, 9 August 2011 6:08 AM
I'm trying to add support for Date and Time datatypes, and functions that use them, within ExpressionManager.
So, questions for the LimeSurvey team:
(2) Any objections to using ISO 8601 as an internal Date/Time standard (e.g. so can store it in that format in the database, but as a String instead of as a DateTime object)?
(3) Any strong preference for PHP vs. Java Date/Time formatting syntax?