Author: shawkins
Date: 2010-10-21 11:08:08 -0400 (Thu, 21 Oct 2010)
New Revision: 2668
Modified:
branches/7.1.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/sybase/SybaseExecutionFactory.java
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/sybase/TestSybaseConvertModifier.java
Log:
TEIID-1303 fix for sybase timestamp to string
Modified:
branches/7.1.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/sybase/SybaseExecutionFactory.java
===================================================================
---
branches/7.1.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/sybase/SybaseExecutionFactory.java 2010-10-20
03:08:28 UTC (rev 2667)
+++
branches/7.1.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/sybase/SybaseExecutionFactory.java 2010-10-21
15:08:08 UTC (rev 2668)
@@ -181,7 +181,7 @@
protected List<?> convertTimestampToString(Function function) {
LinkedList<Object> result = new LinkedList<Object>();
result.addAll(convertDateToString(function));
- result.add(' ');
+ result.add('+');
result.addAll(convertTimeToString(function));
return result;
}
Modified:
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/sybase/TestSybaseConvertModifier.java
===================================================================
---
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/sybase/TestSybaseConvertModifier.java 2010-10-20
03:08:28 UTC (rev 2667)
+++
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/sybase/TestSybaseConvertModifier.java 2010-10-21
15:08:08 UTC (rev 2668)
@@ -185,7 +185,7 @@
LANG_FACTORY.createLiteral("string", String.class)},
//$NON-NLS-1$
String.class);
- helpGetString1(func, "stuff(stuff(convert(varchar, CAST('2003-11-01
12:05:02.0' AS DATETIME), 102), 5, 1, '-'), 8, 1, '-')
convert(varchar, CAST('2003-11-01 12:05:02.0' AS DATETIME), 8)");
//$NON-NLS-1$
+ helpGetString1(func, "stuff(stuff(convert(varchar, CAST('2003-11-01
12:05:02.0' AS DATETIME), 102), 5, 1, '-'), 8, 1,
'-')+convert(varchar, CAST('2003-11-01 12:05:02.0' AS DATETIME),
8)"); //$NON-NLS-1$
}
@Test public void testDateToString() throws Exception {
Show replies by date