1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[SQL] format interval with to_char

Discussão em 'Outras Linguagens' iniciado por Stack, Setembro 24, 2021.

  1. Stack

    Stack Membro Participativo

    Following SQL command

    select TO_CHAR(NVL(arg1 - arg2, TO_DSINTERVAL('0 00:00:00'))) from table1


    produces a result of the format: +000000000 00:03:01.954000.

    Is it possible to enter a special format in the to_char function in order to get a result of format: +00 00:00:00.000?

    Continue reading...

Compartilhe esta Página