Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
'2019-01-01' will consider to be '2019-01-01 00:00:00' which 1546300800000L milliseconds in UTC.
But in other time zone such as '+08:00', do "select date('2019-01-01')" and result.getObject() or result.getDate() will return java.sql.Date object but java.sql.Date.getTime() return 1546272000000L instead of 1546300800000L which it's 8 hours earlier.
Currently, ExecuteSQL return "(java.sql.Date.getTime() - 0) / 86400000" as epoch days
