The nose tip piercing (also Rhino piercing) runs out of the point of the nose inwards, where it escapes again of one of the both nares.
What you see in the end, is only a piercing ball at the point of the nose.
The nose tip piercing is a rather rare piercing. The healing takes about 2 to 3 months and for jewellery a straight piercing barbell is applied.