[fpc-pascal] Timezone information in a dataset datetimefield?- updated
ludo.brands at free.fr
Mon Jul 25 11:57:10 CEST 2011
> > That is also what most of the underlying databases do. They store
> > everything in UTC and convert to local time. Only for those that
> > support "timezoned" field types (fe. oracle timestamp_TZ) you can
> > specify a timezone when entering data. MySQL fe. doesn't
> have support for this.
> > Ludo
> Mmmm. For example, IIRC, Firebird just stores it as entered -
> no UTC conversion. Sensible developers on multi country
> Firebird db projects would probably store convert date/time
> info to UTC in the database.
I'm talking about internal database storage. On the binary level. If you
move a database to a system with a different timezone the dates display
differently when stored internally in UTC.
More information about the fpc-pascal