Carl Vincent wrote: >Do you have any reference from the official standard to this consistency >issue in the format? If so, I can take it up with Salesforce, since they >claim they're standards compliant and that's what's causing my pain.
Referring to ISO 8601:2004. Clauses 2.3.3 and 2.3.4, defining "basic format" and "extended format", apply the concept to an entire date-and-time representation, rather than to segments of it, and doesn't mention any possibility of mixing the formats. Clasue 4.2.5.2, defining how to represent local time together with UT offset, separately shows basic and extended formats where separator usage matches, and doesn't give any explicit permission to mismatch them. Clause 4.3, on combining date with time of day, behaves similarly. -zefram
