Page History
...
Please review the general 1.1.1 Field Type Considerations.
Field Definition Rules
Rules for defining DateTime fields in the repository are:
...
- Refer to Platform Considerations in 1.1.1 Field Type Considerations.
Tips & Techniques
- When you first enable your partition for RDMLX, new DateTime fields have SUTC on and DUTC off. This automatically allows multi-time zone applications, with data displayed and entered in local time, but saved in the database in UTC. This may initially be confusing, but in the end, is what most applications need. If you wish your application to run all in UTC or all in local time, simply modify the default field attributes for the DateTime field type.
- To use a DateTime field, #MyDateTim, as an alpha argument, you simply use #MyDateTim.asString, explicitly stating that you want to use the string representation.
- To initialize a DateTime field to the current time or to set its default to the current time use the Now intrinsic. This ensures that the field is correctly set to UTC format.