Geoff,

> >> Storing these values as ISO8601 strings, combined with our
> >> custom collation,
>
> > Custom collation???
>
> I have benn talking about storing timestamps as ISO8601
> format strings. eg: '2009-06-10T09:44:00+10:00'

I saw that reference in your post and did a little research into the
standard/representation. (That's when I figured out we were using
different sense of timezone)

> We have date, timestamp, and time collations...

Collations for date, timestamp and time?!?!? Now you have my mind
"swimming"...

How can a collation have "intelligence" to parse the time zone part
(i.e. +10:00) of the string and use this to apply logic to the other
values/parts of the string?

My understanding of collations where that they defined a
mapping/sequencing of characters... not to build/apply a "formula".


Sean