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

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

Is it possible to convert CHARACTER to INT

Discussão em 'StackOverflow' iniciado por fdantas, Março 14, 2019.

  1. fdantas

    fdantas Administrator Moderador

    I have a dataset which currently the Event Time (trovalue) is in a CHARACTER format. I need to be able to convert these to an INTERGER so i can SUM these on import so i am able to GROUP the data.

    Currently i have tried to do the following which is returning an error of invalid number string (7498):

    CAST (TemplateRunObject_0.TroValue AS INT)


    I am working from a Progress OpenEdge ODBC and pulling directly into Excel.

    What is the best way to convert CHARACTER to INTERGER

    Continue reading...
    fdantas, Março 14, 2019
    #1

Compartilhe esta Página