Author: shawkins Date: 2012-02-08 20:59:15 -0500 (Wed, 08 Feb 2012) New Revision: 3857 Modified: branches/7.7.x/documentation/reference/src/main/docbook/en-US/content/translators.xml Log: TEIID-1928 adding a note about converting 0 timestamps Modified: branches/7.7.x/documentation/reference/src/main/docbook/en-US/content/translators.xml =================================================================== --- branches/7.7.x/documentation/reference/src/main/docbook/en-US/content/translators.xml 2012-02-08 20:28:18 UTC (rev 3856) +++ branches/7.7.x/documentation/reference/src/main/docbook/en-US/content/translators.xml 2012-02-09 01:59:15 UTC (rev 3857) @@ -328,6 +328,8 @@ should be used on the pool to set ANSI mode: </para> <programlisting>set SESSION sql_mode = 'ANSI'</programlisting> + <para>If retrieving timestamp values, you should set zeroDateTimeBehavior=convertToNull on the URL, otherwise MySQL or Teiid may throw an exception + retriieving '0000-00-00 00:00:00'</para> </listitem> <listitem> <para>