I have noticed the following bugs in the latest release (2.0.0-rc9).
Function TO_CHAR converts DATETIME to char and loose the leading zero for hours.
call TO_CHAR (TIMESTAMP'2010-04-26 09:58:00', 'YYYY-MM-DD HH24:MI:00');
result: 2010-04-26 9:58:00
Function TIMESTAMP cannot convert string value to DATETIME if hour doesn't contain the leading zero:
call TIMESTAMP'2010-04-26 9:58:00'
Thanks, this is being fixed for the next snapshot.
Log in to post a comment.