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?
+2Maybe 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)
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
