| Subject | Re: timestamp inclusive offset to UTC |
|---|---|
| Author | Lester Caine |
| Post date | 2004-04-26T16:31:29Z |
--- In firebird-support@yahoogroups.com, "a_broekhuis"
<akhorahil@h...> wrote:
maths can be carried out
You will need a SMALLINT to give you the offset, but I'd stick with a
TIMESTAMP for the time element
<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 isthat?
> 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
You will need a SMALLINT to give you the offset, but I'd stick with a
TIMESTAMP for the time element