我的Oracle表有一个列tmstp,其中包含TIMESTAMP(3)WITH TIME ZONE数据类型.
当我运行以下查询时
SELECT COUNT(column1)
FROM table1
WHERE tmstp BETWEEN to_timestamp_tz('10-OCT-10 05.00.00.000000000 AM -05:00','DD-MON-RR HH.MI.SSXFF AM TZR')
AND to_timestamp_tz('11-OCT-10 04.59.59.999999999 AM -05:00','DD-MON-RR HH.MI.SSXFF AM TZR');
它提供的计数大约是以下查询的两倍：
SELECT COUNT(column1)
FROM table1
WHERE tmstp >= to_timestamp_tz('10-OCT-10 05.00.00.000000000 AM -05:00','DD-MON-RR HH.MI.SSXFF AM TZR')
AND tmstp <= to_timestamp_tz('11-OCT-10 04.59.59.999999999 AM -05:00','DD-MON-RR HH.MI.SSXFF AM TZR');
我认为他们应该给出相同的结果.关于可能发生的事情的任何输入？我该怎么调试呢？
