21 February 2021
TIMESTAMP Function Returns Different Results When Sorted By Different Direction
Recently, I was working on an issue for customer who faced a weird behaviour that TIMESTAMP conversion function returned different results if different sorting direction was used, meaning, results are different if using ASC vs DESC. To illustrate the issue, please see my test case below: Create a table with testing data: 2. Run below query using Ascending order, the timestamp conversion will fail for […]