Covert Mac Addresses to Integer
Hi, I want to covert MAC address to integer format. They are in the form like below -
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?