проблема была обойдена
следующий код разрешил неразрешимое
PHP код:
TransDate docDate;
str sSQL;
boolean isODBCSQLAccess, isODBCSQLServer;
OdbcConnection connection;
LoginProperty lp;
Statement statement;
ResultSet resultSet;
#odbcConnectionEntries
lp = new LoginProperty();
lp.setDSN('DSN');
lp.setUsername('login');
lp.setPassword('password');
connection = new OdbcConnection(lp);
statement = connection.createStatement();
isODBCSQLAccess = (connection = odbcGetInfoStr(#SQL_DBMS_NAME) == 'ACCESS');
isODBCSQLServer = (connection = odbcGetInfoStr(#SQL_DBMS_NAME) == 'Microsoft SQL Server');
sSQL = 'SELECT *';
if (isODBCSQLServer)
{
sSQL += ', CONVERT(varchar(50), DOCUMENTDATE, 104) AS DOCDATE';
}
if (isODBCAccess)
{
sSQL += ', DOCUMENTDATE AS DOCDATE';
}
resultSet = statement.executeQuery(sSQL);
docDate = str2date(resultSet.getString(i), 123);