| Subject | timestamp inclusive offset to UTC |
|---|---|
| Author | a_broekhuis |
| Post date | 2004-04-26T15:04:52Z |
Is it possible to store a timestamp inclusive its offset to UTC?
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?
TiA
Alexander
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?
TiA
Alexander