Skip to content

Configuring Dates

This tab page is used to configure Database Explorer on date settings.

Date Mask

This form can be used to change the mask to be used for date windows in Database Explorer. You can select the checkbox labeled Use Windows Defaults – which is true by default – meaning that the Windows locale settings are used.

Use Epoch

When this checkbox is selected, two-digit year dates will be converted to four-digit year dates. Usually, you want this support, but if you open a table that still has dates in the two-digit year range, you do not want to see an error on each record that is retrieved. Toggle this option to OFF and you can either normally work with the table or repair the two-digit year date records. The default is the virtual machine default, which is ON.

Epoch Value

The value specified in this form tells the virtual machine on which year an entered two-digit year date will be converted to a date in the range of 1900-1999 and when in the range of 2000-2099. The default value is the default for the virtual machine, which is 30.

Save Epoch To Database Explorer Registry

When checked, the Epoch value will be stored in the registry settings of Database Explorer. This means that the settings for Database Explorer might be different from the other DataFlex programs. The default is OFF.

Sysdate-4

This option tells Database Explorer to set SYSDATE4_STATE to true or false. This means that whenever the system date is retrieved, a two-digit year date or a four-digit year date is returned. Note that a two-digit year date is effectively currently (since 01/01/2000) a three-digit year date since only in the years until 1999 was a real two-digit year date returned by the O/S. The default setting in the virtual machine is usually true.

Date & Time Mask

Users can specify the mask to be used for input on DateTime (DF_DATETIME) columns.

Character Legend

  • d = day
  • M = month
  • y = year
  • H = hour
  • m = minute
  • s = second
  • f = millisecond