BIN2OCT(number[,places])
BIN2OCT function converts a binary number to an octal number. places is an optional field, specifying to zero pad to that number of spaces.
BIN2OCT(110111) equals 67.
OCT2BIN, BIN2DEC, BIN2HEX.