Not only should one use ISO-8601 compliant data types, but also set the time zone and server time according to UTC time.