Y1, try to read this reply to you with attention to Scripture. A one-line reply is not appropriate.
10 And I will pour upon the house of David, and upon the inhabitants of Jerusalem, the spirit of grace and of supplications: and they shall look upon me whom they have pierced, and they shall mourn for him, as one mourneth for his only son, and shall be in bitterness for him, as one that is in bitterness for his firstborn.
Zechariah includes a number of clear references to the life, betrayal & saving work of Jesus, quoted in the Gospels. This passage is one such - John 19:34-37. There is an allusion in Rev. 1:7 which also includes mourning.
Behold, He is coming with clouds, and every eye will see Him, even they who pierced Him. And all the tribes of the earth will mourn because of Him. Even so, Amen.
We need to note that "tribes" (Gk g5443 φυλαὶ φυλή phylē) normally refers to the tribes of Israel, and that "earth/land" (Gk
ge) is normally defined by the context. "Tribes of the earth/land" would therefore be referring to the tribes of the land of Israel, who were guilty of piercing their Messiah, not the whole earth.
When Jesus speaks of "coming in the clouds," the alleged blasphemous words for which he was condemned, he is quoting Daniel 7:13-14, which in context is referring to his ascension to claim his throne, not his second coming for resurrection & judgment. Peter preaches the risen, ascended, reigning Christ and the outpouring of the Holy Spirit at Pentecost in Acts 2.
Read on into Zec. 13:1
In that day a fountain shall be opened for the house of David and for the inhabitants of Jerusalem, for sin and for uncleanness.
That surely refers to the baptism that Peter preached to those who were "cut to the heart," mourning because of their guilt.
That is the wonderful "DAY OF THE LORD" that the prophets look forward to. Zec. 13 goes on to condemn the false prophets & prophecy that denies the fulfilment in Christ Jesus, and which is questioned in the OP.