SELECT *
FROM A
WHERE A_TIME
BETWEEN TIMESTAMP('2008-01-01-00.00.01.000000')
AND TIMESTAMP('2009-01-01-23.59.59.000000')
这里为TIMESTAMP类型的字段A_TIME建立的索引。
SELECT *
FROM A
WHERE A_TIME
BETWEEN TIMESTAMP('2008-01-01-00.00.01.000000')
AND TIMESTAMP('2009-01-01-23.59.59.000000')
这里为TIMESTAMP类型的字段A_TIME建立的索引。