Workarounds These workarounds can be used to get expected results: Use INTERVAL Use CAST to CHAR or VARCHAR Use TIMESTAMP instead of TIME