The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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 - Select Field - 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