TIMESTAMP() and TO_CHAR() functions

2010-04-26
2014-01-19
  • Elena Alexandrova

    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 - 2010-05-03

    Thanks, this is being fixed for the next snapshot.

     

Log in to post a comment.