TIMESTAMP() and TO_CHAR() functions

  • 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'

  • Fred Toussi
    Fred Toussi

    Thanks, this is being fixed for the next snapshot.