[fpc-pascal] Timezone information in a dataset datetimefield?- updated

Ludo Brands 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.

Ludo




More information about the fpc-pascal mailing list