Any specific reason you are comparing only centi-seconds instead of full resolution of FF6 ? Perhaps this will help alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FF6TZD'; Raj On Wed, Apr 17, 2013 at 8:59 AM, Jose Soares <jose.soares@xxxxxxxxxxxxxx>wrote: > > alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FFTZD'; > > -- //www.freelists.org/webpage/oracle-l