Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can dates be returned from SQL select calls?

April 26, 2017dates RETURNED select sql

0

Posted

How can dates be returned from SQL select calls?

1 Answer

0

Posted

Image supports only one data format (implicit). The K8 data type should only used for dates. You must provide details for other than the default conversion of other dates. The Minisoft ODBC and JDBC drivers convert data types from Image to SQL using a set of default maps. These defaults can be replaced by user defined conversions using the Schema Editor utility. This utility can be found in the Administrative tools installation for Minisoft ODBC and JDBC products. Documentation can be found at The Schema Editor can provide more than simple data conversion. You can redefine any section of the record buffer into other data types. For example some Image applications use an X100 to store a series of numbers. In addition, you can define the scale factor if your data is stored in whole number fractions (such as storing currency in an I4 as cents with scale factor of 2).