DateTime storage timezone property

Official Content
This documentation is valid for:
Controls whether DateTime data type attributes are all stored using the same TimeZone in the Database or not. It is also used to enable/disable TimeZone Support.

Scope

Level: Environment

Description

Sets the TimeZone in which the DateTime fields are stored in the Database. Depending on the value set, it enables TimeZone Support.


Values

  • Undefined

The TimeZone of DateTime attributes is Unknown. No conversion from or to the Current TimeZone is made.

This is the default value for Knowledge Bases converted from previous versions in order to preserve compatibility.

 

  • GMT/UTC

All DateTime data type attributes are stored in UTC. Conversion from and to the Current TimeZone is automatic.

This is the default value for new Knowledge Bases.

 

  • Application Server

All DateTime data type attributes are stored in the application server's TZ. Conversion from and to the Current TimeZone is automatic.

Use this value if you are converting your application from previous GeneXus versions and you positively know that the actual data in the database is stored in the application server's timezone. You get TimeZone support without having to convert all DateTime values in your Database.

Run-time/Design-time

This property applies only at design-time.

How to apply changes

To apply the corresponding changes when the property value is configured, execute a Rebuild All.

See Also