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?
0
Comments
Maybe try the REPLACE function to get rid of the colons?