Text Configuration Object Properties window: Options

This tab has the following components:

  • This text configuration object was created with the following option settings   Lists the options that were set when the text configuration object was created.

  • date_format   Sets the format for dates retrieved from the database. The default is YYYY-MM-DD.

  • time_format   Sets the format for times retrieved from the database. The default is HH:NN:SS.sss.

  • timestamp_format   Sets the format for timestamps that are retrieved from the database. The default is YYYY-MM-DD HH:NN:SS.SSS. For Sybase Open Client and JDBC connections the default is set to YYYY-MM-DD HH:NN:SS.SSS.

  • timestamp_with_time_zone_format   Sets the format for TIMESTAMP WITH TIME ZONE values retrieved from the database.

  • uuid_has_hyphens   Sets the formatting of unique identifier values when they are converted to strings.

 See also