FROM TABLE-A where TABLE_B.ISRT_TS BETWEEN TO_TIMESTAMP ('10-JUN-17 04.00.00.000000000 AM','DD-Mon-RR HH:MI:SS.FF9 AM') AND TO_TIMESTAMP('10-Sep-17 03.59.59.999999999HQL囊泡: 1.8.0.10
假设当前的UTC时间是2014/08/25 17:10:00,CST是2014/08/26 01:10:00 (UTC +0800),这意味着科技委已经是第二天了。因此,我不能用这样的东西:// "d" returns "2014-08-25" in local time -> thisis bad
1:10