TEMA

RUNTIME ERROR - Ajuda

Renato Moran preguntado 2 years ago

select name , cast(Extract(day from payday) as int) as 'day', from loan;

Recuerda no enviar soluciones. Tu mensaje puede ser revisado por nuestros moderadores.

  • Higor Costa respondido 1 year ago

    Just take out the the quotes in day and the comma before from loan.

    WRONG:

    ... as 'day', from loan; ...

    RIGHT:

    ... as day from loan; ...
  • Marcielle respondido 1 year ago

    take out the quotes

  • sbrito respondido 2 years ago

    select name, cast((EXTRACT(DAY FROM payday)) as int) as day from loan

  • Renato Moran respondido 2 years ago

    Não funciona sem a , antes do from também

    select name , cast(Extract(day from payday) as int) as 'day' from loan;