Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Covert Mac Addresses to Integer

Hi, I want to covert MAC address to integer format. They are in the form like below -

1e:07:02:15:3a:88
1e:07:02:1b:64:ab

I used the following query to convert them to integer -

Select hex_to_integer(MAC) from Network_table;

It is showing me the following error -

Invalid input syntax for numeric: "0x1e:07:02:15:3a:88"

I think its because the address contains ":" symbols. Any idea how can I overcome this problem?

Comments

  • Jim_KnicelyJim_Knicely Administrator

    Maybe try the REPLACE function to get rid of the colons?

    dbadmin=> select hex_to_integer(replace('1e:07:02:15:3a:88', ':', ''));
     hex_to_integer
    ----------------
     33015448550024
    (1 row)
    
    dbadmin=> select hex_to_integer(replace('1e:07:02:1b:64:ab', ':', ''));
     hex_to_integer
    ----------------
     33015448954027
    (1 row)
    

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.