MAPD JDBC 0.1
select TIME ‘20:10:05’ from T is returning a value shifted by 5 hours (i.e. 15:10:05) . How can one preserve the value as stated?
attempting to insert a value using a TIME literal causes an invalid cast error
insert into TTM(RNUM, CTM) values ( 1, time ‘00:00:00’);
Error: Query failed : Exception: Invalid cast.
having similar CAST issue with timestamp literals
insert into TTS(RNUM, CTS) values ( 1, TIMESTAMP ‘1996-01-01 00:00:00’);