TEMA

Runtime Error

Jonatan Molossi preguntado 3 years ago

Estou recebendo erro de runtime neste código

select name, extract(day from date payday) day from loan

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

  • ┳⋃Đʘ ϾƕƲƥƗȵɢ₳ ↓↓↓ respondido 3 years ago

    Mano, se tem que converter o valor de saida, o extract do day retorna um double.

  • Hasan Ahmed Khan respondido 3 years ago

    Cast the payday into int like below cast(Extract(day from payday) as int)

  • Higor Costa respondido 1 year ago

    Hi, there is no need for this 'date' before the attribute payday. Therefore, after extracting the day from payday you need to cast it as INT. Lastly but no lest, don't forget the semicolon after the 'loan'.