OK thx, I think I will use you solution. To bad timestamp can't store
the offset.

Alexander

--- In firebird-support@yahoogroups.com, "Lester Caine" <lester@l...>
wrote:

> --- In firebird-support@yahoogroups.com, "a_broekhuis"
> <akhorahil@h...> wrote:
> > Is it possible to store a timestamp inclusive its offset to UTC?
>
> No TIMESTAMP is a DOUBLE. Integer part is date, fraction is time, so
> maths can be carried out
>
> > I need to add xml datetime values in a database, and the format is
> > this: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)
> >
> > Do i need a second column, or can I use timestamp or something like
> that?
>
> You will need a SMALLINT to give you the offset, but I'd stick with a
> TIMESTAMP for the time element