You get this at the Temple Of Time, when you have gathered the three Sacred Stones, and the Ocarina of Time. In addition to fighting, you also use this Sword to travel through time.