Main Menu

KB#00649-'Date Column Suffix' of ODBC Administrator Data Source Setup is Case Sensitive


'Date Column Suffix' of ODBC Administrator Data Source Setup is Case Sensitive


The ODBC driver will translate dates that are stored as Julian dates into a recognizable date format. To accomplish this, the data dictionary field column suffix must be passed to the ODBC driver. In the ODBC Administrator, click on the data source and select the Advance or Configure option. Enter the same column suffix used for the column definition in the Data Dictionary in the Column Suffix field. This will allow the driver to automatically translate columns that end with the entered suffix from a Julian value to a human readable format (MM/DD/YY usually). 

However, the suffix information is case sensitive, so the column suffix must be entered in exactly the same case as the column definition in the dictionary. 

Note that this applies to date translations for both OEM date types and Julian dates 


For example, if the dictionary has a column defined in all upper case as INVOICE_DATE, the entry in the Date Column Suffix must contain DATE. 

If the dictionary has definitions for both DATE and date, then both must be entered into the Date Column Suffix field, separated by commas. 

Last Modified: 10/07/1999 Product: BASIS ODBC Driver Operating System: Windows

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel