Dumping and loading DATETIME and DATETIME-TZ fields
You can use EXPORT and IMPORT to dump and load DATETIME and DATETIME-TZ fields. The dump format is fixed and follows the ISO 8601 standard for datetime representations. For DATETIME, there is no time zone offset.
This example shows orders that were created in different time zones:
/* dump_order.p */
OUTPUT TO dump.txt.
FOR EACH Order:
EXPORT SalesRep Carrier OrderDate OrderDateTZ.
END.
OUTPUT CLOSE
For example, assume the OrderDate field in the sports2000.Order table is a DATETIME, and there is an additional DATETIME-TZ field, OrderDateTZ that contains the same date and time as OrderDate. Here is the result in dump.txt:
